Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with logic on row level security

Please can someone help with a row level security query.  I have the following tables EntityA User [email protected] [email protected] [email protected]   EntityB Name I...
  • PaulOlding's avatar
    PaulOlding
    4 years ago

    Anonymous 

    Ah, yes.  Looks like it's the wrong way round.

    VAR _User = USERPRINCIPALNAME()
RETURN
	(_User IN EntityA )
	|| ((NOT _User IN EntityA) && EntityB[Icon] <> "C")

     

    .. here's the results

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Paul.

 

Not sure if the above logic will work.  I need to add the filter to the Entity B table in the Mangage Roles section.