Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use section access to combine two fields (COUNTRY, PRODUCT) with the script below. However I have unwanted results:
I want that USER A is able to see all products from FRANCE and all the countries where the BALL or BASKET has been sold. However, what I get is only products BALL or BASKET sold to FRANCE.
I want that USER G is able to see all products sold to GERMANY and all countries where BALL has been sold. However, what I get is access denied.
How can I combine fields? What are the limitations?
Section Access;
USERS:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, COUNTRY, PRODUCT
ADMIN, ADMIN, ADMIN
USER, A, A, FRANCE
USER, A, A, , BALL
USER, A, A, , BASKET
USER, B, B, FRANCE, BALL
USER, C, C, GERMANY
USER, D, D, UK,
USER, F, F, , BASKET
USER, G, G, GERMANY
USER, G, G, , BALL
];
Section Application;
SALES:
LOAD * INLINE [
COUNTRY, PRODUCT, SALES
SPAIN, BALL, 100
UK, BALL, 500
FRANCE, BASKET, 150
GERMANY, SHOES, 200
FRANCE, BALL, 100
SPAIN, SHOES, 100
UK, SHOES, 50
SPAING, BASKET, 60
FRANCE, SHOES, 100
];
I have added the test document.
Its application is blocked.