How to Update the short description and Description on the catalog item

AjKadam · ‎08-26-2020

Hi All,

I have a requirement Where I want to update the 'short description' of the catalog item to the 'Name of the catalog item' If short description is empty

What is the best way to achieve it

Thanks

Ankur Bawiskar · ‎08-26-2020

Hi,

BR will work only for new records

If you want to fix older catalog items with empty short description then you need to run schedule job.

1) check which catalog items are having empty short description

2) then set short description with catalog item name

Sample script below for job

1) test this for 5 records using setLimit(5);

once verified then remove this line setLimit(5);

updateRecords();

function updateRecords(){

var rec = new GlideRecord('sc_cat_item');

rec.addEncodedQuery('short_descriptionISEMPTY');

rec.setLimit(5); // use for testing then remove this line

rec.query();

while(rec.next()){

rec.short_description = rec.name;

rec.update():

}

}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

AjKadam · ‎08-26-2020

Its not working

Dhananjay Pawar · ‎08-26-2020

Hi,

I have tried same in my PDI and it is working properly.

Try to add logs and check what value you are getting in logs

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

gs.log("Catalog item name = "+current.cat_item.getDisplayValue());

current.short_description = current.cat_item.getDisplayValue();

})(current, previous);

Dhananjay Pawar · ‎08-26-2020

Here is the result,

Before update in RITM

After update in RITM (I updated Quantity field)

Thanks,

Dhananjay.

AjKadam · ‎08-26-2020

Yes you right, actually when we are updating any record or Inserting a new record it is updating correctly

But I have a situation I want to update on an existing catalog items, I don't want to create an event like insert, update, delete

Dhananjay Pawar · ‎08-26-2020

Ok,

I though you wam=nted functionality for RITM, But you want for Catalogs.

Then have before insert update BR on sc_cat_item table.