---
sourceDocument: Australia ServiceNow AI Platform user interface
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/platform-user-interface

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia ServiceNow AI Platform user interface

ft:clusterId :

    - platux

bundleId :

    - platux

workflow :

    - Platform


---

# Add transactions by user related list

# Add transactions by user related list {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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 AllSystem DefinitionRelationships.
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); |
   |-|-|

   {#t_ExampleTransactionsByUser__choicetable_inp_1qj_5r}
4. Click Submit.
5. Navigate to User AdministrationUsers.
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 AdministrationUsers.
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.
{#t_ExampleTransactionsByUser__ul_zc3_kgd_xp}
**Related topics**   

* [Add a related list to a form](https://www.servicenow.com/docs/access?context=configure-form-layout&version=australia&pubname=australia-platform-administration&section=t_AddARelatedList&ft:locale=en-US)

*[\>]: and then