Skip to main content

ServiceNow Agent Workspace - block an agent from creating a ticket from interaction if another user already has

UI Action conditions:

'create incident' button

 add this to the condition field:

&& (new InteractionUtils().intHasRelatedInc(current.sys_id) == 'false')


'create request' button

 add this to the condition field:

&& (new InteractionUtils().intHasRelatedReq(current.sys_id) == 'false')



'create case' button

 add this to the condition field:

&& (new InteractionUtils().intHasRelatedCase(current.sys_id) == 'false')





script include "InteractionUtils" functions:

intHasRelatedInc: function(current_sys_id) { var table_name = 'incident'; var field_name = 'u_interaction'; if (current_sys_id == undefined) current_sys_id = this.getParameter('sysparm_current_sys_id'); var record = this.getGlideRecord(table_name, field_name, current_sys_id); if (record == null) return 'false'; return 'true'; }, intHasRelatedReq: function(current_sys_id) { var table_name = 'sc_request'; var field_name = 'parent_interaction'; if (current_sys_id == undefined) current_sys_id = this.getParameter('sysparm_current_sys_id'); var record = this.getGlideRecord(table_name, field_name, current_sys_id); if (record == null) return 'false'; return 'true'; },


 

intHasRelatedCase: function(current_sys_id) { var table_name = 'interaction_related_record'; var rel_rec_table_name = 'sn_customerservice_case'; if (current_sys_id == undefined) current_sys_id = this.getParameter('sysparm_current_sys_id'); var record = new GlideRecord(table_name); record.addQuery('interaction', current_sys_id); record.addQuery('document_table', rel_rec_table_name); record.query(); if (record.hasNext()) return 'true'; return 'false'; },











getGlideRecord: function(table_name, field_name, field_value) { // Returns a glide record object, which has a specified value in a specified field. if (field_name == undefined) field_name = this.getParameter('sysparm_field_name'); if (field_value == undefined) field_value = this.getParameter('sysparm_user_value'); var user = new GlideRecord(table_name); user.addQuery(field_name, field_value); user.query(); if (user.next()) return user; return null; },


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