You are viewing limited content. For full access, please sign in.

Question

Question

Pathway if value is null in an exclusive gateway

asked on January 12, 2016

How to I write an expression in an exclusive gateway to check if a field is null? Right now I have it checking if the value is less than or greater than 7. If there is no value, the process is terminated. How do I either 1) check for a null value or 2) change the null value to be 0?

Thanks!

 

0 0

Replies

replied on January 12, 2016

Why not make the field required?

0 0
replied on January 12, 2016

It is a required field. I have it auto-populating based on a lookup rule. The problem I am having is that if there is nothing to auto-populate then no value is given. I would instead like for it to be zero.

0 0
replied on January 15, 2016

If you want it to be zero, you can use stored procedure to output zero when search return no results.

0 0
replied on January 13, 2016 Show version history

see https://answers.laserfiche.com/questions/89630/How-to-convert-null-fields-to-0, you can use "/dataset/variable/Points_Prior_to_Infraction[not(node())]" to check for a null value

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.