Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
mov
Employee
Employee

Active Directory load

I'm loading data from Active Directory.  The user select looks more or less like this:


SQL SELECT
distinguishedName,
cn,
displayName,
mail
FROM '$(vLDAP)';

Question: is it possible to load only the users who belong to a certain Group or several Groups before loading Groups themsleves?

Thanks,

Michael

22 Replies
jstar
Contributor III
Contributor III

@rwunderlich We also used your Script in Qlik Sense.

The same Error occurred: EQ_QVX_SIZELIMIT_EXCEEDED

Uncomment your FIRST 1000 line did not fix the error.
I placed the "FIRST 1000" comment before the SQL SELECT (3 lines down). This worked.

BUT:
After that, our Active Directory QVDs are incomplete. So its not a real Workaround.


https://support.qlik.com/articles/000053759?_ga=2.250601665.612611955.1569225269-847784564.154159536...

jt422605
Contributor III
Contributor III

@rwunderlich 

Thanks for your response.  Its commented. But even if  not the result remain unchanged as this is preceding load. And  >1000 rows retrieved from the AD directory before this step. 

rwunderlich

This support article seems to match your case:

https://support.qlik.com/articles/000053759

-Rob