How to create a relationships between task and change request table?

[Erica2]

Hello,

I have been attempting to establish a relationship between the task and change request tables, but I have been unable to display the change request number in the catalog task.

Here is what I have done.  Hope someone could provide suggestions.

It suppose to displays the change request number in the Test Change Request Tab, but it not.

Thank you

[Chaitali_Vale]

Hello @Erica2  , 
Please follow the below scripting : 
var chg = new GlideRecord('change_request');
chg.setValue("parent",current.sys_id);
if(chg.get(current.rfc)){
if(chg.parent == ''){
chg.parent = current.sys_id;
chg.update();
}
}

Please mark my answer correct or helpful, if applicable.
Thanks & Regards,
Chaitali Vale

[Erica2]

Good morning @Chaitali_Vale 

Thank you for providing the code.  I have tried the code, but run in to an issue where all the change request number are returned.  Is it possible that we can filter only the change request number that tied to specific RITM?

[Brian186 · Accepted solution]

Hello @Erica2 ,

Please give it a try and let us know if it works out for you.

[Erica2]

Hi @Brian186 

It is working perfectly. Thank you.