question Re: Related List in Users for their RITMs in Developer forum

Related List in Users for their RITMs

VernYerem — Tue, 05 Mar 2024 19:05:09 GMT

Hello! Looking to add a related list to Users to show what RITMs they've requested. Creating the Relationship and adding it to users is easy enough. But it looks like I need to add "Query with" in the relationship, otherwise it just shows all RITMs in the related list within the user record.

I believe I'll need to query the RTIMs "requested for", but kind of lost from there. Any guidance would be great!

Re: Related List in Users for their RITMs

eagle18 — Wed, 06 Mar 2024 00:53:51 GMT

HI @VernYerem

you need to create a new relationship and add query on the requested for field. The OOB field uses requested_for

Check your RITM or REQ for the correct user field and add this line to the query

current.addQuery('requested_for', parent.requested_for);

Thanks

Hope this helps. Please mark the answer as correct/helpful if this solves your issue.

Re: Related List in Users for their RITMs

James Chun — Wed, 06 Mar 2024 00:57:56 GMT

Hey @VernYerem,

No need to create a new relationship here, use the Requested Item > Requested For from the available list.

Cheers

Re: Related List in Users for their RITMs

Sumanth16 — Wed, 06 Mar 2024 01:23:21 GMT

Hi @VernYerem ,

ou can use "Defined Related List" for your requirement. You can follow below steps

Goto System Definition > Relationships

Click New

Set valid name for your related list

Set Applies to table as sc_request table

Set Queries from table as sys_user table

Use the below code in "Query with"

var group = [];
var grTask = new GlideRecord("sc_task");
grTask.addQuery("request_item",parent.sys_id);
grTask.query();
while(grTask.next()){
  group.push(grTask.assignment_group.sys_id.toString());
}

var users = [];
var grUser = new GlideRecord("sys_user_grmember");
grUser.addEncodedQuery("groupIN" + group.join(","));
grUser.query();
while(grUser.next()){
  users.push(grUser.user.sys_id.toString());
}
current.addEncodedQuery("sys_idIN"+users.join(","));

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

Re: Related List in Users for their RITMs

VernYerem — Wed, 06 Mar 2024 21:51:09 GMT

Ah! Best answer, it's already there and I was searching for the incorrect terms. Thanks @James Chun