Several OMIT values in Section Access

[PavelKas]

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?