2 Replies Latest reply: Nov 4, 2013 11:43 AM by Tanguy Dechiron RSS

    Query with user id in section application

    Tanguy Dechiron

      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