Skip to main content

Complicated Date manipulation: display an escalate button on RITM

//--hide/show escalate button on RITM var bDisplay = false; var bDebug = false; //bDebug = true; //--check if the RITM has passed the estimated delivery time var sDelivery = grRITM.cat_item.delivery_time; var sDelivery_displ = sDelivery.getDisplayValue(); var sDelDT= new GlideDateTime(sDelivery ); if (!gs.nil(sDelivery) && (grRITM.active)) { //--PROBLEM: nowDateTime display format is: dd-mm-yyyy hh:mins:ss //--but RITM OpenedAt display format is: yyyy-mm-dd hh:mins:ss var s_todaysDate = gs.nowDateTime().toString(); var tdArr = s_todaysDate.split(' '); var tdArr2 = tdArr[0].split('-'); var d_TodaysDate = new GlideDateTime (tdArr2[2]+'-'+tdArr2[1]+'-'+tdArr2[0]+' ' + tdArr[1]); var iTodaysDate = d_TodaysDate.getNumericValue(); var d_TimeElapsed = new GlideDateTime(grRITM.opened_at); //d_TimeElapsed.addDaysLocalTime(parseInt(sDelivery_displ)); var iTimeElapsed = d_TimeElapsed.getNumericValue() + sDelDT.getNumericValue(); if (bDebug) { gs.addInfoMessage('delivery days: ' + sDelivery_displ); gs.addInfoMessage('open time + delivery time: ' + iTimeElapsed + '; date val TODAY:' + iTodaysDate + '; time passed?=' + (iTodaysDate > iTimeElapsed)); } if (iTodaysDate > iTimeElapsed) { //--check if the user belongs to groups var userSYSID = gs.getUserID(); var bTasks = false; var grTasks = new GlideRecord('sc_task'); grTasks.addActiveQuery(); grTasks.addQuery('request_item', grRITM.sys_id); grTasks.query(); if (grTasks.getRowCount() > 0) { bTasks = true; } var bRoles = gs.hasRole("admin"); var bGroups = (gs.getUser().isMemberOf('_Service Request_Fulfilment') || gs.getUser().isMemberOf('CustomerServices_SD_Escalations')); if (bDebug) { gs.addInfoMessage('test active tasks: ' + bTasks); gs.addInfoMessage('test grp memberships: ' + bGroups); gs.addInfoMessage('test admin role: ' + bRoles); } bDisplay = (bTasks && (bRoles || bGroups)); } } return bDisplay;

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