Section Access June release Challenge

[deerhunter]

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 !

[pradosh_thakur]

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