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

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });

GlideRecord setValue

setValue(String name, Object value) Sets the specified field to the specified value. Normally a script would do a direct assignment, for example,  gr.category = value . However, if in a script the element name is a variable, then  gr.setValue(elementName, value)  can be used. When setting a value, ensure the data type of the field matches the data type of the value you enter. This method cannot be used on journal fields. If the value parameter is null, the record is not updated, and an error is not thrown https://developer.servicenow.com/app.do#!/api_doc?v=madrid&id=r_GlideRecord-setValue_String_Object