i encounter a problem when edit sectoin access. My goal is : USER1 can see the data from Area 'A' and USER2 can see the data of Brand 'X'. That's to say, USER1 reduce data by only field 'Area' no matter other fields are listed in the section access .
I did a test like below:
section access;
load * inline
[ACCESS,USERID,PASSWORD,%AREA,%BRAND
ADMIN,USER0,123
USER,USER1,123,A,*
USER,USER0,123,*,X
];
section application;
Sales:
load * inline [
Area,Brand,Sales
A,X,10
A,Y,20
B,X,30
B,Y,40
];
left join (Sales)
LOAD * inline
[Brand,%BRAND
X,X
Y,Y
];
LEFT JOIN (Sales)
load * inline
[Area,%AREA
A,A
B,B
];
the result is : Both USER1 and USER2 see the data of Brand X in area A .
