topic Re: Data reduction issues for admins in App Development

Data reduction issues for admins

EhsanPrv — Tue, 18 Oct 2022 04:51:22 GMT

I tried to reduce data via section access. it works like a charm for users with "USER" access, but it also reduces data for ADMINS so weird! like I have A as USER and B as ADMIN, A can see their own data and B(ADMIN) sees only the data of A.

here is my script(I have also ticked "Initial data reduction based on section access" in Document properties--> opening):

star is *;
section Access;
SQL SELECT ACCESS,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_TKN,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_CAP,
upper(USERID) as NTNAME,
'*' as PASSWORD,
'*' as USERID
FROM <MyUsersTable>;
concatenate
load * inline [ACCESS , USERID_TKN, USERID_CAP, NTNAME, PASSWORD, USERID
ADMIN, , , , 123, RELOADER
ADMIN, , , SRV-QVS\ADMINISTRATOR , * , *
];

section Application;

as you can see, I want to reduce data based on two fields (USERID_TKN , USERID_CAP)

@Albert_Candelario

Re: Data reduction issues for admins

vinieme12 — Tue, 18 Oct 2022 05:42:50 GMT

* means LISTED values ( it doesn't mean all values)

refer below

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

Re: Data reduction issues for admins

EhsanPrv — Tue, 18 Oct 2022 08:12:35 GMT

Hey @vinieme12

Actually it appears that you're right. MyUserTable is not complete yet.

Thank you so much

Re: Data reduction issues for admins

Albert_Candelario — Tue, 18 Oct 2022 08:33:17 GMT

Thanks @vinieme12 !

Glad we could resolve it quickly @EhsanPrv

Cheers,

Albert