topic Re: Section Access Wildcard * Not Working in QlikView

Section Access Wildcard * Not Working

asmithids — Mon, 02 Nov 2015 20:24:23 GMT

Hello,

I have the following Section Access script with the * wildcard for two people to give them access to all data in the document. The * wildcard is not working. I've seen posts on this issue, but none have resolved this specific issue.

I would appreciate any assistance with this issue. Thank you!

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, SALESREP
ADMIN, DOMAIN\CFO, *

     USER, DOMAIN\SALESMANGER, *
     USER, DOMAIN\SALESUPERVISOR1, SALESREP1
     USER, DOMAIN\SALESUPERVISOR2, SALESREP2

];
Section Application;

Re: Section Access Wildcard * Not Working

swuehl — Mon, 02 Nov 2015 20:32:43 GMT

I assume the wild card is working as described in the HELP:

A wildcard, i. e. *, is interpreted as all (listed) values of this field, i.e. a value listed elsewhere in this table. If used in one of the system fields (USERID, PASSWORD, NTNAME or SERIAL) in a table loaded in the access section of the script, it is interpreted as all (also not listed) possible values of this field.

Listed values are Salesrep1 and Salesrep2, so SalesManger user should see both values. What do you see?

Re: Section Access Wildcard * Not Working

maxgro — Mon, 02 Nov 2015 20:39:24 GMT

if you want to give access to all data, add an user associated to all the SALESREP

(look at Jonathan's answer here

Re: Issue with Section Access‌

)

Re: Section Access Wildcard * Not Working

prabhu0505 — Mon, 02 Nov 2015 20:46:49 GMT

Basically you have to list all the possible values of reduction field in Section Access table. You can create dummy record for that.

Note: Instead of * leaving blank will bring all values in QV desktop but this behavior is not available on Accesspoint. So it's better to go with dummy record creation.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, SALESREP
ADMIN, DOMAIN\CFO, *

    USER, DOMAIN\SALESMANGER, *
    USER, DOMAIN\SALESUPERVISOR1, SALESREP1
    USER, DOMAIN\SALESUPERVISOR2, SALESREP2

USER, DOMAIN\DUMMY1, SALESREP3

USER, DOMAIN\DUMMY2, SALESREP4

];
Section Application;

Re: Section Access Wildcard * Not Working

cwolf — Mon, 02 Nov 2015 21:13:57 GMT

A better way is to build a linked "Access Table" with a special "Access Field":

§SALESREP:

Load distinct

SALESREP,

SALESREP as §SALESREP

resident YourTableWithSalesRepField;

Load

SALESREP,

'ALL' as §SALESREP

resident §SALESREP;

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, §SALESREP

ADMIN, DOMAIN\CFO, ALL

USER, DOMAIN\SALESMANGER, ALL

USER, DOMAIN\SALESUPERVISOR1, SALESREP1

USER, DOMAIN\SALESUPERVISOR2, SALESREP2

];

Section Application;

Re: Section Access Wildcard * Not Working

cwolf — Mon, 02 Nov 2015 21:22:34 GMT

But don't forget your service user of the distribution service in your section access! He needs a "*":

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, §SALESREP

ADMIN, DOMAIN\QVADMIN, *

ADMIN, DOMAIN\CFO, ALL

USER, DOMAIN\SALESMANGER, ALL

USER, DOMAIN\SALESUPERVISOR1, SALESREP1

USER, DOMAIN\SALESUPERVISOR2, SALESREP2

];

Section Application;

Re: Section Access Wildcard * Not Working

asmithids — Mon, 02 Nov 2015 22:09:51 GMT

Thank you Christian!

Re: Section Access Wildcard * Not Working

asmithids — Mon, 02 Nov 2015 22:10:41 GMT

Thank you Saravana. I like this option for another project.

Re: Section Access Wildcard * Not Working

asmithids — Mon, 02 Nov 2015 22:12:44 GMT

swuehl, thanks for the input. I now have a direction to follow.

Re: Section Access Wildcard * Not Working

asmithids — Mon, 02 Nov 2015 22:17:29 GMT

Thank you maxgro. I responses below did the trick.