Query with user id in section application

[Anonymous]

Hi,

I'm working on an application where I have to implement data reduction.

My section access is working like that:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, USERID, PASSWORD, IDGROUPE

    ADMIN, ADMINQV, ADMINQV, ADMINQV, 1335692

];

Concatenate

LOAD

    'USER' as ACCESS,

    NTNAME,

    IDGROUPE;

SQL select UPPER(s.SPSEUDOSALARIE) as NTNAME,

    gs.IDGROUPE

from SALARIES s

inner join GROUPESSALARIES gs on gs.IDSALARIE = s.IDSALARIE

where s.IDCLIENT = '$(vIdClient)'

and s.BACTIVESALARIE = 1;

Section Application;

The authentification is working fine, now my problem is that the query for searching groups / entities is really huge (about 500 000 000 rows) so I would like to know if it was possible to do a query like that in section application:

LOAD *;

select IDGROUPE, IDENTITY

from TABLE

where iduser = xxx

where 'xxx' is the id of the user connected

[Gysbert_Wassenaar · Accepted solution]

No, that's not possible. The user is not known when the document is reloaded.

[Anonymous]

Thanks! But that didn't solve my problem

I have to search