1 Reply Latest reply: Sep 21, 2017 8:02 AM by pradosh thakur RSS

    Section Access June release Challenge

    buck master

      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 !