Section Access

[kev6brown]

I have the following section access script in my hidden script - 

Section Access;

LOAD * INLINE [
ACCESS,  NTNAME,              OMIT,       SLRLEVEL8,    SLRLEVEL7
ADMIN,     DOMAIN\USER1,   *,             *,                       *
ADMIN,     DOMAIN\USER2,   *,             *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       SPECIAL CARE DENTAL SERVICE
];

Section Application;

When opening the dashboard my log in - DOMAIN\USER1, I can only see EMERGENCY DENTAL SERVICE and SPECIAL CARE DENTAL SERVICE and cannot see NHSNO.

Why is this happening? I should be able to see everything

Thanks

Kev

[marcus_sommer]

A quite simple approach to include/exclude all values with a wildcard is to list these values within section access, maybe with something like:

SA:
load 'USER' as ACCESS, 'NONE' as NTNAME, 
        text(fieldvalue('REDUCTION', recno())) as REDUCTION
autogenerate fieldvaluecount('REDUCTION');

concatenate(SA) load .... from YourSectionAccess;

If there are only a few REDUCTION values they might be simply listed in an inline-statement but like shown such listing against a dummy-user could be also retrieved from the data-set or loaded from a prepared qvd.

Beside this - automatically applied looping and merging approaches might be also used to define all wanted accesses and therefore avoiding the wildcard-stuff.