Why background script update only one record.

[Tarasingh26]

Hi All,

I am trying to update thousand record using background script. Script is working fine but it updates only one record instead of thousand. Please see the code in attachment and provide solutions, if anyone faced this type of issue.

Thanks,

Tara Singh 

[Aman Kumar S · Accepted solution]

Hi @Tarasingh26 ,

updateMultiple() doesn't work in scoped application, would suggest using standard update() function here, it should work just fine.

[Aman Kumar S · Accepted solution]

Hi @Tarasingh26 ,

updateMultiple() doesn't work in scoped application, would suggest using standard update() function here, it should work just fine.

[Aman Kumar S]

Glad, it worked out!

[Riya Verma · Accepted solution]

Hi @Tarasingh26 ,

Hope you are doing great.

Instead of using update multipe use update function. also please try usig below script :

var gr = new GlideRecord("sn_risk_advanced_legal_entities");
gr.query();

while (gr.next()) {
  var gr1 = new GlideRecord("cmn_cost_center");
  gr1.addQuery('u_gl_company_code', gr.u_entity_code);
  gr1.setLimit(100);
  gr1.query();

  while (gr1.next()) {
    gr1.u_legal_entity = "ABC";
    gr1.setWorkflow(false);
    gr1.update();
  }
}

[Tarasingh26]

Thanks Riya 🙏. It is working. Thanks for help. Really struggled with this issue past few days.