User Data Reduction based on Ticketing

Fri, 08 Jul 2011 13:56:09 GMT

Hello,

I try to reduce user data in qv document after a ticketing authentication process (that works).

I've set up to following script in qv document to reduce user's data, but after reloading document, i try to acces to the qvw with ajax client but i prompt to enter login and password then i've been authenticated with tickenting process... if i enter qvadmin\qvadmin its works.

My user are in the Cutom directory and their username are their email adresse --> https://service_url/QvGetTicket/GetTicket.asp?username=Custom\hv@service.com

SECTION Access;

LOAD

uaccess as [ACCESS],

uname as [USERID],

upawd as [PASSWORD],

untname as [NTNAME],

uid as [REDUCTION];

SQL

SELECT

'USER' as uaccess,

'Custom\\' || email as uname,

NULL as upawd,

NULL as untname,

utilisateur_id as uid

FROM sch.utilisateur

WHERE is_active = true AND email <> 'administrateur@service.com'

ORDER BY uname;

LOAD *

INLINE [ACCESS,USERID,PASSWORD,NTNAME,REDUCTION

ADMIN,qvadmin,qvadmin,*,*

ADMIN,,SERVTEST\qvadmin,*];

SECTION Application;

LOAD

uid as REDUCTION,

email as emailuser;

SQL

SELECT

utilisateur_id as uid,

FROM sch.utilisateur

WHERE is_active = true;

Thanks

topic User Data Reduction based on Ticketing in QlikView

User Data Reduction based on Ticketing