Use sql select on request query role type

[c_d]

Hello all,

I'm trying to use a select query on role type configuration. This one doesn't seem to work. is it possible to use a select query ?

[rushikeshvartak]

Create dynamic attributes ( hideen) and use dyanmic attribute

[c_d]

it only works if the attribute is displayed and not hidden.

Regards,
Agnes

[rushikeshvartak]

Can you share configs.

I have tested and it works with hidden

[AmitM]

Hi @c_d , Refer This - https://forums.saviynt.com/t5/identity-governance/filter-selectable-application-roles-based-on-the-s...

DA query (RoleFilter) : select customproperty31as ID from users where entity=${entity}

Role Filter Query : r.customproperty1 = '${RoleFilter}'

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.