Add transactions by user related list

This example adds a relationship, Last 20 transactions, to the user form.

Before you begin

Role required: admin

About this task

The new relationship creates a list of task records opened by the current user.

Procedure

1. Navigate to All > System Definition > Relationships.
2. Click New.
3. Create a relationship with the following values.

   Option	Description
   Name	Last 20 transactions
   Applies to table	User [sys_user]
   Queries from table	Task [task]
   Queries with	current.addQuery('opened_by', parent.sys_id);

4. Click Submit.
5. Navigate to User Administration > Users.
6. Select any user.
   For example, select David Loo.
7. Configure the related lists for the user form and add the related list Last 20 transactions.
8. Navigate to User Administration > Users.
9. Select any user.
   For example, select David Loo.
10. The Last 20 transactions related list displays all task records opened by the current user.

What to do next

Notes 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 topics

• Add a related list to a form