Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
hello,
were you able to find a solution for this problem?
thank you,
Catarina
As far as I recall, Section Access is not supported in Direct Query apps. The documentation doesn't explicitly state this, but it does mention that "Security is handled by the database":
Direct Query limitations | Qlik Cloud Help
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com