Skip to main content

ServiceNow check for null or nil or empty (or not)

Haven't tested these all recently within global/local scopes, so feel free to have a play!

option 1

use an encoded query embedded in the GlideRecord, e.g. 

var grProf=new GlideRecord('x_cls_clear_skye_i_profile');
grProf.addQuery('status=1^owner=NULL');
grProf.query();


even better use the glideRecord addNotNullQuery or addNullQuery

option 2

JSUtil.nil / notNil
(this might be the most powerful. See this link)

example:

if (current.operation() == 'insert' && JSUtil.notNil(current.parent) && !current.work_effort.nil())

 option 3

there might be times when you need to get inside the GlideRecord and perform the check there, for example if the code goes down 2 optional routes depending on null / not null

can use gs.nil:

var grAppr=new GlideRecord('sysapproval_approver');
var grUser=new GlideRecord('sys_user');
if (grUser.get('sys_id', current.approver)){
if (!gs.nil(grUser.email)){
gs.addInfoMessage('resent approval to ' + grUser.email);
}else{
//.....
}
}

check if this works outside global scope!

or


if (!current.start_date.nil()){
}


option 4

use = null

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';
},

 option 6

use empty string, either within GlideRecord filter (for not null) or after the gr.next()
var gr=new GlideRecord('sys_user');
gr.addQuery('name', '!=', '');
gr.query();
if (gr.next()){
gs.print(gr.sys_id);
}


var gr=new GlideRecord('sys_user');
gr.addQuery('active', true);
gr.query();
while (gr.next()){
if (gr.getValue('name')==''){
gs.print(gr.sys_id);
}
}

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