Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Issue with Advanced Query in Technical Rule

tuhink
Regular Contributor
Regular Contributor

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

7 REPLIES 7

NM
Honored Contributor II
Honored Contributor II

@tuhink try adding an or condition 

Or a.employeeType is null

naveenss
All-Star
All-Star

Hi @tuhink use the below condition

(a.employeeType != 'Cust' or a.employeeType is null)
Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

tuhink
Regular Contributor
Regular Contributor

@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
Honored Contributor II
Honored Contributor II

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

tuhink
Regular Contributor
Regular Contributor

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?

tuhink_0-1723477936879.png

 

Use advanced query when multiple conditional conditions 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

NM
Honored Contributor II
Honored Contributor II

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