AnsweredAssumed Answered

User access rule combine multiple queries in one statement

Question asked by Danny Bissett on Dec 17, 2019
Latest reply on Dec 17, 2019 by Mostafa Helmy

I have created a "User Access" rule where I would like to create an expression defining the applications roles with "and" and "Or" statements within the one condition which I have been unable to get to work.


I have created the expression below but it does not work.


approles in (('Oracle Legacy EDC New','Ent1'))
and (approles in (('Oracle Legacy EDC New' ,'En2'))
or approles in (('Oracle Legacy EDC New','Ent3')))


I would have expected the above query to show any user who has Ent1 and either Ent2 or Ent3.


I have attached a screenshot with the rule config.


Can anyone advise what I'm doing wrong or even if this is possible?