I'm working on an application where I have to implement data reduction.
My section access is working like that:
LOAD * INLINE [
ACCESS, NTNAME, USERID, PASSWORD, IDGROUPE
ADMIN, ADMINQV, ADMINQV, ADMINQV, 1335692
'USER' as ACCESS,
SQL select UPPER(s.SPSEUDOSALARIE) as NTNAME,
from SALARIES s
inner join GROUPESSALARIES gs on gs.IDSALARIE = s.IDSALARIE
where s.IDCLIENT = '$(vIdClient)'
and s.BACTIVESALARIE = 1;
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: