Incident and change OOB servicenow allows for duplicate numbers. I need that stopped as it is impact

[R1R3]

Incident and change OOB servicenow allows for duplicate numbers. I need that stopped as it is impacting reporting. There are articles online how to fix/stop this from occurring

[Dr Atul G- LNG]

HI @R1R3 

Could you please tell us, where you finding these duplicates? In related list or form or where. A screesnshot will be helpful.

[swathisarang98]

Hi @R1R3 ,

You can refer below articles for getting duplicate value,

https://www.servicenow.com/community/developer-forum/seeing-duplicate-incidents-with-same-number/m-p... 

Also you can create a business rule as mentioned in the servicenow doc ,

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/field-admini... 

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[Sumanth16]

Hi @R1R3 ,

solution1 :

go to the dictionary of number field, you can set the default value of the number field as

solution2 : 

go to the system properties list and search for "glide.itil.assign.number.on.insert", and set the value as 'true'.

Solution 3:

create before business rule on table with below code:

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

// Add your code here

var gr = new GlideRecord('incident');

gr.addQuery('number', current.number);

gr.query();

if(gr.next()) {

gs.addErrorMessage("An incident is already present with the same number " + current.number);

current.setAbortAction(true);

}

})(current, previous);

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda