Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ! I've got a problem with section access. I have two lists : PRODNAME and REGION. While I execute this code
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODNAME
ADMIN, user1,*
USER, user2,HAYAT
USER, user3,EVYAP
USER, user4,KALINA
USER, user5,COSMETICA
USER, user6,CONSTRMAT
USER,user7,DEFAULT
USER, user8,NEVCOSMET
USER, user9,FOOD
USER, user10,TRICOT
USER, user11,PAPER
];
Section Application;
It works great but when I change instead of PRODNAME to REGION it doesn't want to open if I enter as user.
What I need to change?
Thank you !
try this
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REGION1
ADMIN, dcucuta, *
ADMIN, dtest,UCRAINA
ADMIN, dcucuta, ROMANIA
ADMIN, dcucuta, GERMANY
ADMIN, dcucuta, BULGARIA
ADMIN, dcucuta, GERMANY
user, adovbenco, CHINA
];
Section Application;
LOAD F1 as REGION,Upper(trim(PurgeChar(F1,0123456789.))) as REGION1;
LOAD * INLINE [
F1
03. Regiunea Nord
05. Regiunea Transnistria
Istanbul
01. Municipiu Chisinau
02. Regiunea Centru
04. Regiunea Sud
04 Turkey
05 Rusia
<NA>
06 Bulgaria
09 Germany
03 Ucraina
02 Romania
08 Poland
07 Azerbaidjan
01 Moldova
10 China
];
What is your LOAD statement when using REGION field in section access? Can you paste here?
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REGION
ADMIN, user1,*
USER, user2,GERMANY
USER, user3,TURKEY
USER, user4,FRANCE
USER, user5,RUSSIA
USER, user6,ROMANIA
USER,user7,SPAIN
USER, user8,NETHERLAND
USER, user9,USA
USER, user10,GB
USER, user11,AUSTRALIA
];
and is the Section Application also defined for REGION?
Have you enabled 'Strict Exclusion' ? If so, check unchecking that if opens. If opens, that means your REGION field doesn't have data for that user.
Yes ! It opens with no changes I mean all REGIONS are visible for user
what do you mean?
You have to ensure that the field name and section access field are exactly same, REGION and REGIONS are different. Also make sure that you load the region data using UPPER().
Could you please paste the complete script ? we need to check your section application part where the actual reduction logic is defined
can you look in my script please, pass for hidden script is : denis