Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I'm trying to reduce data by Section Access and I'm trying to figure out how to combine Section Access for two fields.
I have sports data and what I want is the following:
Every user is able to see top8 results from all countries, but every user is only able to see the full results from their own countries.
So far I've been able to let users only see the full results from their own country, but no results from other countries. And seperatly I've been able to let users only see a top8 of results but no 9th places f.e. for their own countries. But I have not managed to combine these two in the way I described above.
I got the restriction on countries working like this:
Star is ALL;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, COUNTRY
ADMIN, ADMIN, ADMIN, ALL
USER, USER1, USER1, NETHERLANDS
USER, USER2, USER2, UNITED STATES
USER, USER3, USER3, BRAZIL
USER, USER4, USER4, RUSSIA
];
Section Application;
CountryData:
LOAD * INLINE [
COUNTRY, Country
NETHERLANDS, Netherlands
UNITED STATES, United States
BRAZIL, Brazil
RUSSIA, Russia
];
And I got the restriction on results working like this:
Star is ALL;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, N_RANK
ADMIN, ADMIN, ADMIN, ALL
USER, USER1, USER1, TOP8
USER, USER2, USER2, TOP16
USER, USER3, USER3, TOP16
USER, USER4, USER4, TOP16
];
Section Application;
RankData:
LOAD * INLINE [
N_RANK, n_Rank
TOP8, 1
TOP8, 2
TOP8, 3
TOP8, 4
TOP8, 5
TOP8, 6
TOP8, 7
TOP8, 8
TOP16, 1
TOP16, 2
TOP16, 3
TOP16, 4
TOP16, 5
TOP16, 6
TOP16, 7
TOP16, 8
TOP16, 9
TOP16, 10
TOP16, 11
TOP16, 12
TOP16, 13
TOP16, 14
TOP16, 15
TOP16, 16
];
How can I combine these two to get the restrictions like I want them as desribed above in bold?
Any help would be greatly appreciated 