Several OMIT values in Section Access

PavelKas — Mon, 25 Sep 2023 06:34:47 GMT

Hi everybody,

I have a loaded table like

Properties:

USERID, ACCESS, Property

1, User, A

2, User, B

3, User, C

And I have a script loading an app with a field, let say SensitiveField, in the Data Model.

I want to give an access to this field only to users with Property = A and I act like the following way in Section Access:

Left Join(Properties)

Load

USERID,

ACCESS

'SensitiveField' as OMIT

Resident Properties

Where Property <> 'A';

And it works.

Now I want to hide another field, AnotherSensitiveField, and give access to it only for users with Property = C.

How should I act?

topic Several OMIT values in Section Access in Management & Governance