Auto Increment Numerical Value in Catalog Item Variable "Project number"

prasad8
Giga Expert

Hi,

My requirement :

I have created one new variable in catalog item "Project Number", for this project number variable i need auto numbering functionality like incident number.

 

find_real_file.png

Please help me on this requirement.

 

 

Thanks,

 

 

9 REPLIES 9

Hey,
Did you get a chance to implement the solution?

 

Hi @Ankur Swami ,

 

Sorry for the late reply,

I have created business rule for getting the Auto number.

Table : RITM

Conditions: Before - insert - Item is XYZ 

Script:

(function executeRule(current, previous /*null when async*/ ) {

var reqItemGr = new GlideRecord('sc_item_option');
reqItemGr.addEncodedQuery('item_option_new.question_textSTARTSWITHproject number');
reqItemGr.orderByDesc('value');
//reqItemGr.orderByDesc('created');
reqItemGr.setLimit(1);
//reqItemGr.orderBy('value');
reqItemGr.query();

if (reqItemGr.next()) {
//var number = parseInt(reqItemGr.value);
var number = reqItemGr.value;
if (current.variables.request_type == 'original') {
number++;
} else if (current.variables.request_type == 'part_2') {

number = parseInt(current.variables.project_number) + 0.2;
} else {

number = parseInt(current.variables.project_number) + 0.3;
}
}
current.variables.project_number = number.toString();
})(current, previous);

 

 

Thanks

 

Hi Ankur,

 

Can you please advice me here

I want to Auto increment the variable in the MRV's and i need this to achieve one of my requirement below

https://community.servicenow.com/community?id=community_question&sys_id=f9fcfeaddba68150e2adc22305961951

Please suggest me how to add the variable inside the MRV's for the auto increment ?

Hi Ankur,

I tried to implement this but I am getting value like this INC2.0, INC3.0 ......... like this instead of INC00001, INC00002 do you have any idea why I am getting this ?

PallaviPandey
Tera Contributor

Hi Prasad, are you able to implement this ?