How to relate multiple change request records to a single RITM?

ArpitaVK · ‎03-28-2024

Hello

Currently, in the related list of RITM, related change records are displayed. When I open the change the records, the corresponding RITM should be displayed in the change record's related list. For that, I have configured a BR:

Table: change_request

When to run: after insert, update

Script:

(function executeRule(current, previous /*null when async*/ ) {

// Add your code here

var parentSysId = current.parent;

var ritmRec = new GlideRecord('sc_req_item');

ritmRec.get(parentSysId);

ritmRec.parent = current.sys_id;

ritmRec.update();

})(current, previous);

What is happening is, the corresponding RITM is shown only on the latest change record added in the related list of RITM. If we open previously added change records in the related list of RITM, even though the parent is populated with that RITM number, the RITM record is not present in its related list.

One of solutions that was suggested for this is to create M2M relationship. But can it be created for existing related list instead of adding a new related list?

Harish KM · ‎03-28-2024

Hi @ArpitaVK updated your script:

var parentSysId = current.parent;

var ritmRec = new GlideRecord('sc_req_item');

ritmRec.addQuery('sys_id',parentSysId );

ritm.query();

//for multiple ritm do a while loop to get all records matching parent sysid

while(ritm.next())

{

ritmRec.parent = current.sys_id;

ritmRec.update();

}

Regards
Harish

ArpitaVK · ‎03-28-2024

Hello @Harish KM

I updated the script, but now no any change record has RITM in its related list. I even added the logs to check upto which line the code is running; not a single log is recorded.

Harish KM · ‎03-28-2024

Hi @ArpitaVK how are you creating change from RITM? which field on change holds ritm syssid?

Regards
Harish

ArpitaVK · ‎03-28-2024

Hi @Harish KM
I am creating change on RITM using either of the following two ways:

1. creating new change request record from the related list

2. editing the change request related list (slushbucket)

And 'Parent' field on the change request record holds the number of RITM.