Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

tdechiron
New Contributor III

Query with user id in section application

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

1 Solution

Accepted Solutions

Re: Query with user id in section application

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


talk is cheap, supply exceeds demand
2 Replies

Re: Query with user id in section application

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


talk is cheap, supply exceeds demand
tdechiron
New Contributor III

Re: Query with user id in section application

Thanks! But that didn't solve my problem

I have to search

Community Browser