Check if field is a specific value or empty

[Mark Vancil2]

Using this is an IF check on a workflow, and not sure where I'm going wrong. It's not catching when the field is empty.

var gr = new GlideRecord("sys_user");
gr.get(current.variables.request_for.toString());
gs.warn(gr.u_jobfamily);

if (gr.u_jobfamily == 'SB') {
   answer = 'yes';
	
} 
else if (gr.u_jobfamily.nil()) {
	answer = 'yes';
}
else {
	answer = 'no';

}

[Tony Chatfield1]

Hi, have you tried testing against an empty string

if(gr.u_jobfamily == '')

[Mark Vancil2]

Yeah, I probably should have mentioned, it was that way when I noticed that an empty value got through, and I changed it to the code above while troubleshooting it.

In both versions, empty values gets through.

[Alok Ranjan Das]

Hi Mark,

What type of field is "u_jobfamily"? Is the rest functionality working as expected? Could you please give a try using the below code:

gr.u_jobfamily=='' // instead of gr.u_jobfamily.nil()

Kindly mark my answer as Correct and Helpful based on the Impact.

Regards,

Alok

[Mark Vancil2]

Yeah, I probably should have mentioned, it was that way when I noticed that an empty value got through, and I changed it to the code above while troubleshooting it.

In both versions, empty values gets through.