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.
1 ACCEPTED SOLUTION
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
