- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 10:39 PM
Hi All,
We have a requirement where i need to show RITM's parent as well child of that particular RITM in requested item related list on RITM form.
Pls help.
Solved! Go to Solution.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2021 12:51 AM
Hi Nikita,
So here you go
My Example has this:
RITM0010028 is parent of RITM0010029
RITM0010029 is parent of RITM0010027
RITM0010029 is parent of RITM0010026
1) Create defined relationship from left navigation -> Relationships -> System Definition
Name - Related RITMs
a) Applies to table - sc_req_item
b) Queries from table - sc_req_item
Script:
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
var ritmSysId = parent.parent;
var currentSysId = parent.sys_id;
// get the childs
var arr = [];
var gr = new GlideRecord("sc_req_item");
gr.addQuery("parent","IN", currentSysId);
gr.query();
while(gr.next()) {
arr.push(gr.getValue('sys_id'));
}
current.addQuery("sys_id", "IN", arr.toString()).addOrCondition("sys_id", parent.parent);
})(current, parent);
Then add it on the related list by Configure -> Related Lists
Output: RITM0010029 related list will show it's child RITM0010027 and RITM0010026 and also it's parent RITM0010028
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 10:47 PM
Hi,
By default it shows the child items in the related list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 11:10 PM
hi Asif,
I want to show ritm's child as well as parent number in the list.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 11:20 PM
Hi,
What do you mean by showing parent number in the list?
The list is already showing you all the child items of the RITM which you have opened.
Kindly elaborate the requirement.
Mark the comment as helpful/correct if this has answered your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2021 04:50 AM
hi Asif,
Pls let me elaborate my requirement.
If RITM1 is having parent as RITM2 and RITM1 is the child of RITM 3. In that case i want to show RITM2 and RITM3 in the related list WHEN RITM1 form is opened.