Business Rule - Help with update script.

[Lisa Goldman]

Hello,

The following Business Rules should update the short descript with description.  Please help review the code.  Thanks

Business Rule: After and Update:

     

var catalogItem = new GlideRecord('sc_cat_item');

        if (catalogItem.get('sys_id', current.getUniqueValue)) {

            // Update the catalog item

            catalogItem.short_description = current.description; // Update with the desired field to be updated

            catalogItem.update();

        }

})(current, previous);

[Sohail Khilji]

Hi @Lisa Goldman ,

What you are missing is >  getUniqueValue();

Or simply copy this code inside your business rule ...:

var item = current.getUniqueValue();

var catalogItem = new GlideRecord('sc_cat_item');
catalogItem.addQuery('sys_id', item );
catalogItem.query();
if(catalogItem.next())
 {
            catalogItem.short_description = current.description; 
            catalogItem.update();
}

[Lisa Goldman]

Good morning @Sohail Khilji 

Thank you for pointed out my mistake.  I copied the exactly code you provided and it is still not working. What have I done wrong?

[Sohail Khilji]

Hi @Lisa Goldman ,

try this code:

var catalogItem = new GlideRecord('sc_cat_item');
catalogItem.addQuery('sys_id', current.sys_id );
catalogItem.query();
if(catalogItem.next())
 {
            catalogItem.short_description = current.description; 
            catalogItem.update();
}

[Appanna M]

Hello @Lisa Goldman ,

Can you confirm the table name for the BR?

Try the below code:

(function executeRule(current, previous /*null when async*/ ) {
//Add your code here
var catalogItem = new GlideRecord('sc_cat_item');
        if (catalogItem.get('sys_id', current.getUniqueValue())) {
            // Update the catalog item
            catalogItem.short_description = current.description; // Update with the desired field to be updated
            catalogItem.update();
        }

})(current, previous);
 7 Views