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