Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good mornig,
i should done some test to convert report from plugin to AJAX.
I have a problem with section access:
if in SECTION ACCESS i write:
SQL SELECT
LOWER(cutenti) AS "NTNAME"
,'USER' as "ACCESS"
,commoper as JOB
from GenAnag.User_All_jobs
UNION
select 'saco6071' as NTNAME,'ADMIN' AS "ACCESS",'00001' AS JOB FROM DUAL;
when I try to open a Report from AJAX console with saco6071 credential it works OKù(only 00001 JOB is visible)
while if i Write:
SQL SELECT
LOWER(cutenti) AS "NTNAME"
,'USER' as "ACCESS"
,commoper as JOB
from GenAnag.User_All_jobs
UNION
select 'saco6071' as NTNAME,'ADMIN' AS "ACCESS",'*' AS JOB FROM DUAL;
when I try to open a Report from AJAX console with saco6071 credential i can't access to report(while if i open report directly from qlikview works.i see all Job)
someone can help me or have any ideas?
many thanks and best regards 🙂
i chek the Strictly exclusion and works!:-) many thanks!