Thank you for your proposal
However I am not generating my list via "inline" I do an import from SQL-database
Formula: UPPER(If (Gruppe = 'SALES',"Test",))as SALESMAN;
UPPER(If (Gruppe = 'SALES',"Test",*))as SALESMAN;
does not work and
UPPER(If (Gruppe = 'SALES',"Test",'*'))as SALESMAN;
If you upload sample application, that will be great..
Using "*" in section access doesn't mean "all values for field" but "all listed values for field within section access". If you want a user to get all information, set nothing instead the asterisk for any admin user, and as many lines as possible values for each user.
Hope that helps
Also i will suggest store section access data into the Qvd and then load into application. Use NTID not NSTID.
Thanks for your answer.
I know the selection coming from using * however I wanted to test if they can open the file then at least.
I do not have a *.qvd
I have tried the same approach with NTNAME but there is no difference.
The code which I am using is simple:
SET vCatalog = 'cee_datawarehouse';
CONNECT TO [Provider=SQLOLEDB.xxxx);
STAR is *;
UPPER("Access") as ACCESS,
UPPER("SID") as NTSID,
UPPER("System") as SYSTEM,
UPPER("Gruppe") as GRUPPE,
UPPER(If (Gruppe = 'SALES',"rp_id_m",))as SALESMAN;
SQL SELECT * FROM "cee_datawarehouse".dbo."QlikViewProperties";
The result is then (if put the same Load-statement in the Section application):
ACCESS GRUPPE NTSID SALESMAN SYSTEM USER POLENGF S-1-5-21-xxx-123 AT USER SALES S-1-5-21-xxx-124 AT94 DE ADMIN GF S-1-5-21-xxx-125 AT
The user S-1-5-21-xxx-123 cannot open the file
The user S-1-5-21-xxx-124 is able to open the file and gets the right data-set.
The user (admin) S-1-5-21-125 is able to open the file and gets the full data-set