Team,

Is there a way to get list of users who qualify for BR technical rules based on the basic or advanced conditions that are configured in rules.

For example -

User attributes - state = test, country = abc, location = test1

BR Tech Rule - a.state=test and a.country=abc and a.location = test1

As the user qualifies the tech rule, the query/report should show user and tech rules which he qualifies for BR process.

Issue -

As the advanced conditions are stored as string in the hanarule table, you cannot equate this in any where clause. Tried using dynamic variables / session variables, but the db vizualiser or analytics does not support it.

Is there a way to get such list using existing (supported) SQL capabilities of Saviynt ?