Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone see why this is not working? (Thanks in advance)
We want the app to react as follows:
USR1 = Can see all
USR2 = Can see only department = 2234, PROCCD = ABC and OMIT DEPTID = 1000
USR3 = Can see only department = 3200, PROCCD = EFG and OMIT DEPTID = 2000
//Script code:
Section Access;
LOAD
Upper(ACCESS) AS ACCESS,
Upper(USERID) AS USERID,
Upper(DEPTID) AS DEPTID,
Upper(PROCCD) AS PROCCD,
Upper(OMIT) AS OMIT
FROM [$(vSectionData)Security.xlsx]
(ooxml, embedded labels, table is Sheet1);
Section Application;
The excel reads:
ACCESS | USERID | DEPTID | PROCCD | OMIT |
ADMIN | USR\USR1 | * | * | |
USER | USR\USR2 | 2234 | ABC | 1000 |
USER | USR\USR3 | 3200 | EFG | 2000 |
Both (DEPTID & PROCCD) are fields in the model !
i know it has been long and you might have found an solution also still.
Things to check
1: DEPTID AND PROCCD are caps in the model.
2: * means all listed value not all value in the model.
3: Your use of OMIT is wrong. It omits a filed for a specific user, not the field value