Check if field is a specific value or empty

Mark Vancil2 · ‎04-02-2020

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

}

Alok Das · ‎04-02-2020

Thanks for the update. However if you feel the issue is still there you can give a try with below script:

answer = ifScript();
function ifScript(){
	var gr = new GlideRecord("sys_user");
	gr.get(current.variables.request_for.toString());
	gs.warn(gr.u_jobfamily);
	
	if (gr.u_jobfamily == 'SB') {
		return 'yes';
		
	}
	else if (gr.u_jobfamily.nil()) {
		return 'yes';
	}
	else {
		return 'no';
		
	}
}

Regards,

Alok

View solution in original post

Tony Chatfield1 · ‎04-02-2020

Hi, have you tried testing against an empty string

if(gr.u_jobfamily == '')

Mark Vancil2 · ‎04-02-2020

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 Das · ‎04-02-2020

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 · ‎04-02-2020

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.