Business Rule to update custom Release field on Task with Requested Item Related List field Release

Siddharth Parna
Tera Contributor

Hi 

I am working on a business rule to Update custom field(Release- created by me on Task Table) to update with Task Related Request Item Related List field Product Release.

I want to make sure that once Release is linked with RITM,then Product Release  value is updated on RITM and then with business rule make to update custom Release field value on Task.

I tried writing the business rule but unable to achieve the automation .

This is the business rule I am using

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

    var reqItem = new GlideRecord('sc_req_item');
    if (reqItem.get(current.request_item)) {
        var rel = new GlideRecord('rm_release');
        rel.addQuery('u_ritm', reqItem.sys_id); //Unable to fetch the relation here in place of u_ritm
        rel.query;
        if (rel.next()) {
            current.u_release = rel.u_release; // u_release is new release record value created on task
  }

    }

})(current, previous);

 

Product Release.PNG
     
5 REPLIES 5

SuyashJ41731830
Tera Contributor

Hi
@Siddharth Parna 
Script

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

// Make sure the task has a linked Request Item
if (current.request_item) {
var reqItem = new GlideRecord('sc_req_item');
if (reqItem.get(current.request_item)) {
// Now get the product release from RITM - assuming it's a reference field 'u_product_release'
if (reqItem.u_product_release) {
// Update the custom Release field on Task
current.u_release = reqItem.u_product_release;
} else {
// Clear the release field if no product release found
current.u_release = null;
}
}
}

})(current, previous);