topic Re: How to setup Section Access on a Direct Query App in App Development

How to setup Section Access on a Direct Query App

Murray — Tue, 12 Dec 2023 19:11:05 GMT

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?

Re: How to setup Section Access on a Direct Query App

catarina1911 — Mon, 14 Apr 2025 11:50:42 GMT

hello,

were you able to find a solution for this problem?

thank you,

Catarina

Re: How to setup Section Access on a Direct Query App

marksouzacosta — Mon, 14 Apr 2025 13:30:10 GMT

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