- 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-04-2021 05:00 AM
Hello Nikita,
It is not possible to do in related lists. As related lists shows the child items only.
For this you have to go with a custom relationship.
Mark the comment as helpful/correct if this has answered the question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 11:35 PM
Hi,
Why to show the same RITM as Child of itself?
Doesn't sound to be a valid business requirement
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-04-2021 04:51 AM
Hi Ankur,
It's client's requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2021 10:49 PM
Hi Nikita,
Why you want to show the current RITM in the related list as well when the RITM cannot be parent of Itself
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 11:26 PM
hi Ankur,
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.