Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Roles Request Query is not working

Bharadwaj
Regular Contributor
Regular Contributor

Hi,

We are trying to populate the enterprise roles if the roles metadata match the identity metadata. For eg. we want to show the roles If roles.customproperty10 matches with users. orgunitid. We are using the below query, but it is not working for us in EIC V23.7.

(and rl.customproperty10 in (select users.orgunitid from Users users where users.id={currentUser}))

Forum Reference: https://forums.saviynt.com/t5/general-discussions/request-roles-query-to-filter-roles-based-on-reque...

 

Could you please let me know what could be the issue here?

 

Thanks!

3 REPLIES 3

Saathvik
All-Star
All-Star

@Bharadwaj : What is the behaviour when you say it is not working? It is showing all roles? or not showing anything? 

Also is there any error in logs?

Also can you try below query as well

and rl.customproperty10 = (select users.orgunitid from Users users where users.id={currentUser} and users.orgunitid is not null)

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Bharadwaj
Regular Contributor
Regular Contributor

This worked. I missed to do the null check. Thanks for your help!

 

Manu269
All-Star
All-Star

@Bharadwaj can you try checking this article :

Use case of Request Roles Query (saviyntcloud.com)

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.