Issue in related list

[Pratham Singh]

I have 2 table. The 1st table name is User Tracking and the 2nd table name is User attendance. I have multiple data of a single user in the user tracking table and but only one data in the user attendance table. So i want to display the user tracking data in the user attendance table in related list

[Sandeep Rajput · Accepted solution]

@Pratham Singh Please refer to this documentation to know how a related list can be added and filter can be applied

https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/administer/form-adminis...

In the example Applies to table and queries from table are same. But in your case Applies to table will be user attendance and queries from table will be user tracking.

Also in the filter you can use

current.addQuery('u_user',parent.u_user); //Assuming both the tables have u_user column parent here is the record of user attandance table. 

[Pratham Singh]

Thankyou for your accurate response. It solved my Query.

[Sandeep Rajput]

@Pratham Singh Glad to know the solution helped 🙂