Auto Numbering for Existing Records

[Jag5]

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.

[Alikutty A]

Please try this out, I am assuming in your number maintainance you have selected 7 digits and starting number as 1000

var prefix   = "SW";

var zero = "000";

var counter = 1000;

var gr = new GlideRecord('cmdb_software_product_model');

gr.query();

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

counter += 1;

var num = counter.toString();

gr.u_number = prefix+zero+num;

gr.update();

}

Thanks

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

[Jag5]

Yes that's true. I kept the starting number as 1000.

I tried the above script but it din't work now as well. The number dint get populated.

Thanks,

Jag.

[Alikutty A]

Thats wierd It worked on my developer instance.

Are you working on a developer instance?

Thanks

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

[Jag5]

Yes, I am working on our dev instance. Do we need to remove any default value in Number at dictionary level?

Thanks,

Jag.

[Alikutty A]

No change is required on the number dictionary. Can you show me a screenshot of your number maintenance record?

Also see what log this code prints when you execute it

var prefix   = "SW";

var zero = "000";

var counter = 1000;

var gr = new GlideRecord('cmdb_software_product_model');

gr.query();

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

counter += 1;

var num = counter.toString();

gs.print(prefix+zero+num);

gr.u_number = prefix+zero+num;

gr.update();

}

Thanks

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