Contents Now Platform User Interface Previous Topic Next Topic Add transactions by user related list Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Add transactions by user related list This example adds a new relationship, Last 20 transactions, to the user form. Before you beginRole required: admin About this taskThe new relationship creates a list of task records opened by the current user. Procedure Navigate to System Definition > Relationships. Click New. Create a new relationship with the following values. OptionDescription Name Last 20 transactions Applies to table User [sys_user] Queries from table Task [task] Queries with current.addQuery('opened_by', parent.sys_id); Click Submit. Navigate to User Administration > Users. Select any user. For example, select David Loo. Configure the related lists for the user form and add the related list Last 20 transactions. Navigate to User Administration > Users. Select any user. For example, select David Loo. The Last 20 transactions related list displays all task records opened by the current user. What to do nextNotes and limitations: This query returns all task records opened by the user. The related list defaults to displaying 20 task records per page. The parent variable refers to the Applies to table. In this case, it applies to the User [sys_user] table. Querying against a record sys_id is a common query method for relationships. Related TasksAdd a related list On this page Send Feedback Previous Topic Next Topic
Add transactions by user related list This example adds a new relationship, Last 20 transactions, to the user form. Before you beginRole required: admin About this taskThe new relationship creates a list of task records opened by the current user. Procedure Navigate to System Definition > Relationships. Click New. Create a new relationship with the following values. OptionDescription Name Last 20 transactions Applies to table User [sys_user] Queries from table Task [task] Queries with current.addQuery('opened_by', parent.sys_id); Click Submit. Navigate to User Administration > Users. Select any user. For example, select David Loo. Configure the related lists for the user form and add the related list Last 20 transactions. Navigate to User Administration > Users. Select any user. For example, select David Loo. The Last 20 transactions related list displays all task records opened by the current user. What to do nextNotes and limitations: This query returns all task records opened by the user. The related list defaults to displaying 20 task records per page. The parent variable refers to the Applies to table. In this case, it applies to the User [sys_user] table. Querying against a record sys_id is a common query method for relationships. Related TasksAdd a related list
Add transactions by user related list This example adds a new relationship, Last 20 transactions, to the user form. Before you beginRole required: admin About this taskThe new relationship creates a list of task records opened by the current user. Procedure Navigate to System Definition > Relationships. Click New. Create a new relationship with the following values. OptionDescription Name Last 20 transactions Applies to table User [sys_user] Queries from table Task [task] Queries with current.addQuery('opened_by', parent.sys_id); Click Submit. Navigate to User Administration > Users. Select any user. For example, select David Loo. Configure the related lists for the user form and add the related list Last 20 transactions. Navigate to User Administration > Users. Select any user. For example, select David Loo. The Last 20 transactions related list displays all task records opened by the current user. What to do nextNotes and limitations: This query returns all task records opened by the user. The related list defaults to displaying 20 task records per page. The parent variable refers to the Applies to table. In this case, it applies to the User [sys_user] table. Querying against a record sys_id is a common query method for relationships. Related TasksAdd a related list