Showing Requested Items List on User Record

jmiskey · ‎07-21-2017

If we want to show a Requested Items related list on the User Record, we can follow the method described here:Configure related lists in forms - ServiceNow Express Support

and choose options like:

Requested Item->Submitter

or

Requested Item->Beneficiary

If we choose both, we will have two Requested Item related list tabs (one tab for each list).

Is there an easy way to show both in one single related list tab?

So, it would return all records where the user is either the Submitter or Beneficiary in one single list.

Thanks

antin_s · ‎07-21-2017

Hi Joe,

You can create a new Relationship as shown below and add it to the User Table as Related List.

You might want to replace the fields "opened_by" and "request.requested_for" with your fields.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

View solution in original post

jmiskey · ‎07-24-2017

OK, I added a new relationship that looks like this:

I then went to the User record, when to Configure, and brought up the Related Lists. But I do not see this new option listed in there.

Do I have to do something to it to be able to see it?

antin_s · ‎07-24-2017

Hi Joe,

I dont think you need "sc_req_item." in your query conditions, because current means 'sc_req_item' only. Look at my query, I havent added 'sc_req_item'. In which table, thee 2 fields (opened_by & u_beneficiary) are present?

Thanks

Antin

jmiskey · ‎07-24-2017

Yes, that worked! thank you very much!