Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/12/2024 08:26 AM
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
Solved! Go to Solution.
08/12/2024 08:36 AM
08/12/2024 08:40 AM
Hi @tuhink use the below condition
(a.employeeType != 'Cust' or a.employeeType is null)
08/12/2024 08:46 AM
@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.
08/12/2024 08:47 AM
@tuhink , didn't quite understand your above comment..did it not work?
08/12/2024 08:53 AM
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?
08/12/2024 08:55 AM
Use advanced query when multiple conditional conditions
08/12/2024 08:57 AM
@tuhink it won't work in basic config ..