Issue with Advanced Query in Technical Rule

[tuhink]

Hello there!

I am facing one scenario where I am using Advanced Query of technical rule. In my system few users have no value present in employee type. Few users have employee type as 'Cust'. In some existing technical rule when I am adding the condition a.employeeType != 'Cust', its not showing the employee Type with 'Cust' value. But the Issue is, its also excluding the users who has no value in employee type field.

FYI when I am using a.employeeType = 'Cust' its working as expected

[NM · Accepted solution]

@tuhink try adding an or condition 

Or a.employeeType is null

[naveenss · Accepted solution]

Hi @tuhink use the below condition

(a.employeeType != 'Cust' or a.employeeType is null)

[tuhink]

@NM thank you, it worked. What to do if we not using the advanced query? I am seeing same kind of issue there also. I have tried the same way like you suggested for advanced query, but its not working.

[NM]

@tuhink , didn't quite understand your above comment..did it not work?

[tuhink]

Hi @NM it worked.

I am facing the same issue when I am not using the advanced query for the same use case. But its not working if I am using the same kind of method. Can you please suggest anything here?

[rushikeshvartak]

Use advanced query when multiple conditional conditions 

[NM]

@tuhink it won't work in basic config ..