Skip to main content

ServiceNow record producer variables in a business rule

ServiceNow record producer variables in a business rule


//--new code, RDS Dec2018
g_scratchpad.rp_sysid='';
var producerVars_allVars = new GlideRecord('question_answer');
//var allVars = [];
producerVars_allVars.addQuery('table_sys_id', current.sys_id);
//--Exclude Label and Container variables
producerVars_allVars.addQuery('question.type', '!=', 11);
producerVars_allVars.addQuery('question.type', '!=', 19);
producerVars_allVars.addQuery('question.type', '!=', 20);
//--note: UI Macro is question.type=14
producerVars_allVars.query();
//gs.addInfoMessage(current.producer.sys_id);
while(producerVars_allVars.next()){
//gs.addInfoMessage(producerVars_allVars.question.type + ' ' + producerVars_allVars.question.name.toString()  + ' ' + producerVars_allVars.value.toString());
if (producerVars_allVars.question.name.toString()=='hr_rp_sysid'){
g_scratchpad.rp_sysid=producerVars_allVars.value;

if (producerVars_allVars.value=='4b3a65e7dbce6b007e07db11ce96193c'){
//--some logic here specific to the 'HR Feedback' form:
//--get the 'sysparm_newcase=true' bit of the URL populated via the record producer. there must be a simpler way to do this using glide but couldn't spot it
var completeURL = GlideTransaction.get().getRequest().getHeader("referer");
var matchValArr=completeURL.match("sysparm_newcase=(.*)&").toString().split(',');
var isNewCase = matchValArr[1];
if (isNewCase=='true'){
g_scratchpad.newcase = 'true'; //--passed over to the client script
}
}
break;
}
//allVars.push(producerVars.question.name.toString());
}
//-----

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