question Update multiple records with background script in Developer forum

Update multiple records with background script

Dawid2 — Tue, 14 Sep 2021 08:42:15 GMT

I need to update couple of the records with the help of the background script. The field I need to update is a free text field, which = to value NAAM. I need to update it so it says NAM.

Here's the script I'm using but it's not working - anyone knows why?

var rg = new GlideRecord('incident');
rg.addQuery("u_alias1", "=", "NAAM");
rg.query();
while(rg.next){
rg.u_alias1="NAM";
rg.update();
}

Re: Update multiple records with background script

Martin Ivanov — Tue, 14 Sep 2021 08:44:45 GMT

try with

var rg = new GlideRecord('incident');
rg.addQuery("u_alias1", "=", "NAAM");
rg.query();
while(rg.next()){
rg.setValue('u_alias1','NAM');
rg.update();
}

Re: Update multiple records with background script

Martin Ivanov — Tue, 14 Sep 2021 08:45:24 GMT

The problem was that you were missing the brackets after the .next() method.

Please makr Correct and Helpful. Thanks

Re: Update multiple records with background script

Himanshu Gupta1 — Tue, 14 Sep 2021 08:52:30 GMT

Please do you setworkflow(false) and autosysfield(false) as well so that it wil not trigger or update user that you doing something at backend

var rg = new GlideRecord('incident');
rg.addQuery("u_alias1", "=", "NAAM");
rg.query();
while(rg.next()){
rg.u_alias1="NAM";
rg.setWorkflow(false);
rg.autoSysFields(false);
rg.update();
}

Please mark it helpful and correct if your query get resolved

Best Regards

Himanshu Gupta

Re: Update multiple records with background script

Voona Rohila — Thu, 24 Nov 2022 14:41:48 GMT

Hi Dawid

Try this

var rg = new GlideRecord('incident'); rg.addQuery("u_alias1", "=", "NAAM"); rg.query(); rg.setValue('u_alias1',"NAM"); rg.updateMultiple();

https://community.servicenow.com/community?id=community_article&sys_id=53e36473dbd244502be0a851ca96190d

you can also achieve this with no-coding using update-selected/update all option.

https://docs.servicenow.com/bundle/rome-platform-user-interface/page/use/using-lists/task/t_EditMultiRecUsingEditingForm.html

Re: Update multiple records with background script

Community Alums — Thu, 24 Nov 2022 14:24:01 GMT

Hi Rohila

Never directly assign a value to a variable and call multipleUpdate()!

That will cause all records of the table to have the value changed whatever the query!!

Always use .setValue() together with updateMultiple()!

Please fix your comment or remove it before someone, for some reason, decides to use your way of updating the records and actually destroy data in the table!

Best regards

Nuno Agapito

Re: Update multiple records with background script

Voona Rohila — Thu, 24 Nov 2022 14:44:19 GMT

Thank You Nuno, I modified the code.