Why background script update only one record.

Tarasingh26
Tera Expert

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 

20230703_180517.jpg

3 ACCEPTED SOLUTIONS

Hi @Tarasingh26 ,

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

 

 

View solution in original post

Aman Kumar S
Kilo Patron

Hi @Tarasingh26 ,

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

 

View solution in original post

Riya Verma
Kilo Sage

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();
  }
}

 

 
 

View solution in original post

12 REPLIES 12

Glad, it worked out!

 

Riya Verma
Kilo Sage

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();
  }
}

 

 
 

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