Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
Have an issue with section access.
I Set next:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, UPPER(City) as CITY
ADMIN, ADM, 123, ROMA
];
Section Application;
So, when I opening document as this admin i should see only Roma. But still see all the cities in the list.
Please help to figure out what am I doing wrong?
Your Field name City in Section access is different to City in our City table. Case sensitive issue. Can you try below:
Section Access;
LOAD ACCESS, USERID, PASSWORD, UPPER(CITY) AS CITY;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, CITY
ADMIN, ADM, 123, ROMA
];
Section Application;
Country:
LOAD * INLINE [
Country, Country_S
France, FR
Germany, GR
Italy, IT
];
City:
LOAD UPPER(City) AS CITY, Country_S;
LOAD * INLINE [
City, Country_S
Paris, FR
Marseille, FR
Berlin, GR
Hamburg, GR
München, GR
Köln, GR
Frankfurt am Main, GR
Roma, IT
Milano, IT
Napoli, IT
Torino, IT
];
hello
are you sure of you load inline
isn't it
load
LOAD
ACCESS, USERID, PASSWORD, UPPER(City) as CITY;
load * inline [
LOAD * INLINE [
ACCESS, USERID, PASSWORD, City
in you load, you create a column named [UPPER(City) as CITY] which doesn't match with a column CITY
so no securty
Your Field name City in Section access is different to City in our City table. Case sensitive issue. Can you try below:
Section Access;
LOAD ACCESS, USERID, PASSWORD, UPPER(CITY) AS CITY;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, CITY
ADMIN, ADM, 123, ROMA
];
Section Application;
Country:
LOAD * INLINE [
Country, Country_S
France, FR
Germany, GR
Italy, IT
];
City:
LOAD UPPER(City) AS CITY, Country_S;
LOAD * INLINE [
City, Country_S
Paris, FR
Marseille, FR
Berlin, GR
Hamburg, GR
München, GR
Köln, GR
Frankfurt am Main, GR
Roma, IT
Milano, IT
Napoli, IT
Torino, IT
];
HI Nataliia,
PFA, Solution.
Cheers,
Pankaj
Thank you for your help, Olivier.
Hi Vishwarath. It helps, I see my mistake. Thank you.
Hi Pankaj. Thank you much for your help.