Requested Query in Role Type

[SwagatDas13]

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?

  

[rushikeshvartak]

r.customproperty5 IN ('${userdept}')

[SwagatDas13]

Thanks @rushikeshvartak , Tried the same but not getting any Role

 

 

[rushikeshvartak · Accepted solution]

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},%'

[SwagatDas13]

Thanks a lot, you saved me 😊