There are a million posts about section access and I think reading them is making me more confused.
I am trying to apply simple logic that would look like....
sectionAccess; LOADACCESS, USERID, PASSWORD, GROUP FROM [..\Passwords\QV_Passwords.xlsx] (ooxml, embeddedlabels, tableis CompPlan);
sectionapplication; LOADUSERID, SECURITY_DEPT FROM [..\Passwords\QV_Passwords.xlsx] (ooxml, embeddedlabels, tableis CompPlan);
ACCESS
USERID
PASSWORD
GROUP
SECURITY_DEPT
ADMIN
ADMIN
ADMIN
ADMIN
ADMIN
M00768
BMGCOMP
ADMIN
ADMIN
M01122
BMGCOMP
ADMIN
ADMIN
M09849
BMGCOMP
ADMIN
USER
M09000
BMGCOMP
CHIEF
SURGERY
The blanks in Security Department should be ALL departments. I have tried combinations with * and 'Star is *' (which I still do not understand) but when I run the script the reduction for 'M09000' works correctly and when I sign in as an ADMIN everything is blank.
Is there a way to say ALL departments without listing out every single one (There are quite a few!)??
Sorry, I think the problem might be in my over simplified sample. I took that same logic and applied it to my actual application and it wasn't the same results. ALTHOUGH... I am using your logic combined with something that Nandkishor posted earlier and it seems to be working right now... but I am hesitant to say that because I have thought that before.
It's the same problem that Katie had at the beginning. If you want to use data reduction, you must:
- Have a separate field for the data reduction in Section Access. It cannot be USERID or any other system field. If you want user to see all listed data, use *. If you want user to see all data (listed or not), use blank.
- Have the same data reduction field in section application.
- The field must have name all caps and values all caps.
