User Data Reduction based on Ticketing

[#1]

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,

     email

          FROM sch.utilisateur

          WHERE is_active = true;

Thanks