Skip to main content

Enforce unique numbering - avoid duplicates on child tables of task

Enforce unique numbering - avoid duplicates on child tables of task

useful reading here:


https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/field-administration/concept/c_EnforcingUniqueNumbering.html


for my solution I went for the recommended business rule solution, and defined the business rule to run on "task" table and inherited by child tables (incident etc)

still trying to get to the bottom of how exactly the issue of duplicate incident numbers being generated on the incident form arises, but in the meantime no more duplicate tickets in our instance!

examples of how the transaction logs might be checked for the issue:

/syslog_transaction_list.do?sysparm_query=sys_created_onBETWEENjavascript%3Ags.dateGenerate('2018-05-03'%2C'12%3A50%3A00')%40javascript%3Ags.dateGenerate('2018-05-03'%2C'12%3A50%3A59')%5EurlSTARTSWITH%2Fincident%5Esql_count%3E0%5Eresponse_time%3E25%5Esys_created_by%3DSmith

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

ServiceNow - script include: build up the results as a JSON object (array) - example 2

function call var sCurrentGroupMembers = new <script_include> (). getGroupMembers ( group_sysid ); gs . print ( 'sCurrentGroupMembers:' + sCurrentGroupMembers ); var oGroupMembers = JSON . parse ( sCurrentGroupMembers ); gs . print ( JSON . stringify ( oGroupMembers . users )); oNewGroupMember = JSON . parse ( group_members ); var oGroupConfig = getGroupDeltas ( oGroupMembers . users , oNewGroupMember ); gs . print ( JSON . stringify ( oGroupConfig . remove )); gs . print ( JSON . stringify ( oGroupConfig . add )) output : *** Script: sCurrentGroupMembers: {"manager":"3b2649efdb0f8c10cc0652f3f39xxxxx", "email":"", "type":"33a2226edb99c340edfc7cbdae96xxxx", "description":"Created for xyz", "users":[{"user":"3b2649efdb0f8c10cc0652f3f396xxxx"},{"user":"856a8f71db3d73041b4ffc45ae96196a"},{"user":"3752771