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-10-2017

Hello Alikutty,

I ran the script as an On Demand Scheduled Job and now the records got updated as expected. Thank you so much for your help.

Thanks,

Jag.

bidya1 · ‎04-11-2018

Thanks Michael, I ran into similar situation and your script came into my rescue.

SMuir · ‎06-14-2021

I have it working now,

I changed the number counter to 100, ran the script and it worked.