Auto Numbering for Existing Records

Jag5 · ‎04-05-2017

Hello Experts,

I have created auto numbering for existing software model table. The issue is we have few old records for which we need numbering as well but it works only for newly created records. Is there a way to generate numbering for existing records as well. Thank you in advance.

Thanks & Regards,

Jag.

Michael Ritchie · ‎04-05-2017

Sorry change line 6 to gr.u_number so...

var gr = new GlideRecord("cmdb_software_product_model"); 

gr.orderBy('sys_created_on'); 

gr.query(); 

while (gr.next()) { 

   var nm = new NumberManager('cmdb_software_product_model'); 

   gr.u_number = nm.getNextObjNumberPadded(); 

   gr.autoSysFields(false);   // Do not update sys_updated_on, sys_updated_by, and sys_mod_count 

   gr.setWorkflow(false);       // Do not run any other business rules 

   gr.update(); 

}

View solution in original post

Jag5 · ‎04-05-2017

I have 825 records in total.

Thanks,

Jag.

Alikutty A · ‎04-05-2017

Ok, My logic is based on your total count

var prefix = "SW";

var zero = "0000";

var counter = 0;

var gr = new GlideRecord('cmdb_software_product_model');

gr.query();

while(gr.next() && counter<825){

counter += 1;

gr.u_number = prefix+zero+counter;

gr.update();

}

Please check it

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

Jag5 · ‎04-05-2017

Hi Alikutty,

Number is still showing empty. It did not work.

Thanks,

Jag.

Alikutty A · ‎04-05-2017

Let me try it out, I will get back in some time.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

Jag5 · ‎04-05-2017

Sure. Thank you for your help.