I have a section access set on a qvw as follow:
Star is *;
UPPER(NTNAME) AS NTNAME,
(ooxml, embedded labels, table is Users);
Name as [Project Manager],
USERKEY as %PROJECT_MANAGER
Name as [Program Manager],
USERKEY as %PROGRAM_MANAGER
Now everything is working fine except one scenario: when I have a project and any of the Project manager or the Program Manager is not listed on the security excel file then this project doesn't show up on the qvw.. even I am logged in as Admin.
Anyway I can fix this.
Here is a sample of the security file:
I didn't get what you mean by blanck field value.
Thxs so much for all your help.
I noticed an issue happening when i do the space instead of the *
The names of the users from the security excel file appear on the Program manager and Project manager list boxes on the application..
for example, the the QV administrator User name which is used to reload the qvws appears on the list boxes while it is not part of any of the projects..
Any idea on what could be done wrong?
Thxs again for all your help!