Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use security to limit the data the user can see per region + limit the tab the user can see
It doesn't work unless I do a left join to the section application
I can get the tab visibility to work but not both without the left join - as displayed below
Thanks in assisting me what I am missing
Rick
===========================
Section Access;
security:
LOAD * INLINE [
ACCESS, NTNAME ,ROLE
USER,BNDNA\ARORAR,A
];
Section Application;
SheetAccess:
LOAD * Inline [
ROLE,REGION,SH01,SH02,SH03,
A,SOUTH,0,0,1
A,WEST,0,0,1];
left join (SheetAccess)
regiondata:
LOAD * INLINE [
REGION, dpp_id, name, location
SOUTH, BAd111, badguy, MD
NORTH, BAd333, badguy22, MDVA
WEST, BAd222, badguy22, MDVA
];
Section Access;
security:
LOAD * INLINE [
ACCESS, NTNAME ,ROLE
USER,BNDNA\ARORAR,A
];
Section Application;
SheetAccess:
LOAD * Inline [
ROLE,REGION,SH01,SH02,SH03,
A,SOUTH,0,0,1
A,WEST,0,0,1];
//left join (SheetAccess)
regiondata:
LOAD * INLINE [
REGION, dpp_id, name, location
SOUTH, BAd111, badguy, MD
NORTH, BAd333, badguy22, MDVA
WEST, BAd222, badguy22, MDVA
];
and put condition on each sheet
for sheet id 3
SH03=1
Its working its showing only SH03 and for region its showing only south and west without left join
I don't get the same results - maybe i have the setting setup incorrectly.
Can i ask what is the difference in setting tab to =SH03 vs SH03=1
It just doesnt work for me
Thanks