Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No, that's not possible. The user is not known when the document is reloaded.
No, that's not possible. The user is not known when the document is reloaded.
Thanks! But that didn't solve my problem
I have to search