Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/23/2024 08:47 AM - edited 10/23/2024 08:49 AM
Hi All,
We have a requirement that the application role must be filtered based on the Dynamic Attribute selection. Example : If users department name is 'A' the respective roles need to be filtered for Selection. Department name is stored in Role CustomProperty 5(Single and multivalued).
We are able to filter out the roles for single value using query : r.customproperty5='${userdept}' but if CustomProperty5 contains multiple values(eg : A,B,C,D) then we are getting error occured in ARS form.
Can anyone help what query can we write to fix this?
Solved! Go to Solution.
10/23/2024 08:51 AM
r.customproperty5 IN ('${userdept}')
10/23/2024 08:56 AM
10/23/2024 08:58 AM
Can you share logs
You can use this also
r.customproperty5 LIKE '%${userdept}%' OR
r.customproperty5 LIKE '%${userdept},%' OR
r.customproperty5 LIKE '%,${userdept}%' OR
r.customproperty5 LIKE '%,${userdept},%'
10/23/2024 09:01 AM
Thanks a lot, you saved me 😊