Hi all, I have one issue while giving sheet level section access to user where I have to give ALL PLANTS access of Sheet1 to 50004579@ABC.COM and give P002,P003,P004 plants access to same user (50004579@ABC.COM )for Sheet2. (Note: We are using different source for both sheet and later concatenated)
Section Access; SA_TAB: LOAD ACCESS, USER.EMAIL, SHEET_CONTROLLER AS SHEET_CONTROLLER, SUBFIELD(PLANT,'|') AS PLANT, PLANT AS PLANT_SA Inline [ ACCESS, USER.EMAIL, PLANT, SHEET_CONTROLLER ADMIN, MMKNDQLIKVIEW@ABC.COM, ALL, ALL ADMIN, AFSQSENSEADMIN@ABC.COM, ALL, ALL ADMIN, 50004383@ABC.COM, ALL, ALL USER, 50004579@ABC.COM, ALL, 1 USER, 50004579@ABC.COM, P002|P003|P004, 2 ]; Section Application;
Sheet_Access:
Load * Inline [ SHEET_CONTROLLER 1 2 12 ALL ];
In sheet we have given Show condition for Sheet1 =SHEET_CONTROLLER=1 or SHEET_CONTROLLER ='ALL' for Sheet2 =SHEET_CONTROLLER=2 or SHEET_CONTROLLER ='ALL'