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

[AjKadam]

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

[Dhananjay Pawar]

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

current.short_description = current.name;

})(current, previous);

[Ankur Bawiskar]

@Aj 

for existing catalog items you need to write one time 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

[Dhananjay Pawar]

Hi,

Did you get chance to work on my provided solution?

Thanks,

Dhananjay.

[AjKadam]

Hi Dhananjay,

I tried. Still I am not getting excepted output

On new records it is working fine but it didn't update on existing records

[Ankur Bawiskar · Accepted solution]

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