Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Create related list on User Table and Requested Item Table

phil34
Tera Expert

I am quite new to Service Now but I would like assistance to filter a related list please.

On the sys_user table form I am displaying a custom relationship related list based on the sc_req_item table. The issue I have is that the related list displays all the records in the sc_req_item table.

I only want the ones where caller in the sc_req_item table matches the user in the the current displayed user form.

 e.g, UserFirstName+" "+UserLastName = Caller(in requested Item list)

Below is the screenshots of the required result and also the relationship I have

Any assistance would be greatly appreciated.

find_real_file.png

 

find_real_file.png

1 ACCEPTED SOLUTION

Hi @phil 

yes, that is possible. The following relationship should do the job.

 

find_real_file.png

Kind regards
Maik

View solution in original post

5 REPLIES 5

Hello Maik,

I did miss something the Capital "V" in Value.

All working as expected now thankyou very much.

Phil