Hi everyone,
i've a problem with a section access in my .qvw.
I create this section access in the script:
sub CaricaSectionAccess2
UtentiCapoAreaSA:
NoConcatenate
load Distinct
trim([Key Agente Riferimento Cliente]) as [Key Agente Riferimento Cliente SA],
trim([Key Agente Cliente Codice]) as [Key Agente Cliente Codice SA]
resident AgentiClienti
where [Key Agente Riferimento Cliente] <> '' and not isnull([Key Agente Riferimento Cliente]);
MapKeyAgenteNomeUtente:
mapping load
trim(DITTA) & '-' & trim(CODICE_AGENTE) as [% Key MapKeyAgenteNomeUtente],
trim(UTENTE) as [% Value MapKeyAgenteNomeUtente]
FROM
Dati\utenti_ruoli.xls
(biff, embedded labels, table is utenti$);
Ruoli:
LOAD
trim(RUOLO) as RUOLO,
trim(PRINCIPALE) as PRINCIPALE,
trim(VENDITE) as VENDITE,
trim(ACQUISTI) as ACQUISTI,
trim(ORDINICLIENTI) as ORDINICLIENTI,
trim(ORDINIFORNITORI) as ORDINIFORNITORI,
trim(BUDGET) as BUDGET,
trim(AGENTI) as AGENTI,
trim(MAGAZZINO) as MAGAZZINO,
trim(PRODUZIONESEDE) as PRODUZIONESEDE,
trim(REPORTDINAMICO) as REPORTDINAMICO,
trim(DASHBOARD) as DASHBOARD,
trim(SALES) as SALES
FROM
Dati\utenti_ruoli.xls
(biff, embedded labels, table is ruoli$);
section access;
Access:
LOAD * INLINE [
ACCESS,NTNAME,IDAGENTE,AZIENDAID,RUOLO
ADMIN,PIPPO\USER1,*,*,SUPERUSER
ADMIN,PIPPO\USER2,*,*,SUPERUSER
ADMIN,PIPPO\USER3,*,*,SUPERUSER
ADMIN,PIPPO\USER4,*,*,SUPERUSER
ADMIN,PIPPO\USER4,*,*,SUPERUSER
ADMIN,PIPPO\USER5,*,*,SUPERUSER
ADMIN,PIPPO\USER6,*,*,SUPERUSER
];
TabSA:
load Distinct
IDAGENTE as IDAGENTE_SA
resident AgentiClienti;
join (TabSA)
load Distinct
AZIENDAID as AZIENDAID_SA
Resident Aziende;
join (TabSA)
load Distinct
RUOLO as RUOLO_SA
Resident Ruoli;
Concatenate(Access)
load
'ADMIN' as ACCESS,
'PIPPO\USER1' as NTNAME,
IDAGENTE_SA as IDAGENTE,
AZIENDAID_SA as AZIENDAID,
//CODICEFAMIGLIAID_SA as CODICEFAMIGLIAID,
//CODGRUPPOSTATISTICO1ID_SA as CODGRUPPOSTATISTICO1ID,
RUOLO_SA as RUOLO
resident TabSA;
Concatenate(Access)
LOAD
trim(TIPO_UTENTE) AS ACCESS,
trim(UTENTE) as NTNAME,
if
(
len(trim(CODICE_AGENTE)) = 0,
'*',
trim(DITTA) & '-' & trim(CODICE_AGENTE)
) as IDAGENTE,
if(len(trim(DITTA)) = 0,'*',trim(DITTA)) as AZIENDAID,
//if(len(trim(CODICE_FAMIGLIA)) = 0,'*',trim(CODICE_FAMIGLIA) ) as CODICEFAMIGLIAID,
//if(len(trim(CODICE_GRUPPO_STATISTICO1)) = 0,'*',trim(CODICE_GRUPPO_STATISTICO1)) as CODGRUPPOSTATISTICO1ID,
trim(RUOLO) as RUOLO
FROM
Dati\utenti_ruoli.xls
(biff, embedded labels, table is utenti$);
concatenate(Access)
load
'USER' as ACCESS,
ApplyMap('MapKeyAgenteNomeUtente',[Key Agente Riferimento Cliente SA],'NOAG') as NTNAME,
[Key Agente Cliente Codice SA] as IDAGENTE,
SubField(trim([Key Agente Riferimento Cliente SA]),'-',1) as AZIENDAID,
//'*' as CODICEFAMIGLIAID,
//'*' as CODGRUPPOSTATISTICO1ID,
'AGENTE' as RUOLO
resident UtentiCapoAreaSA
order by [Key Agente Riferimento Cliente SA]
;
section Application;
end sub
after i've publish the file in my WebServer and i make a reaload with administrator user in managment console.
i've set on the objects of my sheet the visibility trought an ACL based on user defined in the .xls, but every user can see all the objects.
What could it be the problem?
Thanks in advance.
