Data reduction issues for admins

[EhsanPrv]

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)

QlikView 

@Albert_Candelario 

[vinieme12 · Accepted solution]

* 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/man...

[EhsanPrv]

Hey @vinieme12 

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

Thank you so much

[Albert_Candelario]

Thanks @vinieme12 ! 

Glad we could resolve it quickly @EhsanPrv 

Cheers,

Albert