An issue with section access

[Peony]

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?

[olivierrobin]

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

[vishsaggi · Accepted solution]

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

];

[passionate]

HI Nataliia,

PFA, Solution.

Cheers,

Pankaj

[Peony]

Thank you for your help, Olivier.

[Peony]

Hi Vishwarath. It helps, I see my mistake. Thank you.

[Peony]

Hi Pankaj. Thank you much for your help.