Roles Request Query is not working

[Bharadwaj]

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!

[sk · Accepted solution]

@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)

[Bharadwaj]

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

[Manu269]

@Bharadwaj can you try checking this article :

Use case of Request Roles Query (saviyntcloud.com)