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

I'm receiving the following error:

 

The number of arguments is invalid.  Function CONTAINSROW must have a value for each column in the table expression.

 

Is it because the User field is not specified in Entity A?

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
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