I've been able to setup Section access on a non-direct-query app and works fine.
I now have a need to do the same on a direct query app but it does not work with the exact same method used.
Here is an example with a fake email.
Section Access;
entitlement_data:
load * inline [
ROLE ,USEREMAIL ,NUMBER
ADMIN ,tester@email.com ,
];
SectionAccess:
NOCONCATENATE LOAD
UPPER(ROLE) AS ACCESS,
UPPER(USEREMAIL) AS USER.EMAIL,
SUBFIELD(NUMBER,'|') AS ACCOUNT_ID
RESIDENT entitlement_data;
drop table entitlement_data;
When I Load data I get this message:
Started loading data
Operation aborted
Data has not been loaded. Please correct the error and try loading again.
The Data connection works fine and I have many tables mapped and they have the upper case ACCOUNT_ID in them.
Is this doable in Direct Access?