Section Access June release Challenge

deerhunter — Tue, 25 Jul 2017 21:49:03 GMT

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:

Both (DEPTID & PROCCD) are fields in the model !

Re: Section Access June release Challenge

pradosh_thakur — Thu, 21 Sep 2017 12:02:32 GMT

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