Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

LDAP query Active Directory for field 'description' array

Dear all,

I'm trying to get some informational data out of active directory via LDAP connection.

UserTable:

LOAD

    name,

    type,

    description;

SQL select

    name, type, description   

FROM 'LDAP://$(RootDse)'  WHERE objectCategory='Computer'

This is an example with just 3 fields. name, type, description,

while name and type will load correctly. but 'description' will always be empty in qlikview (but not NULL), although there is definitely a value into this AD-field.

May it be that this field is an array and if yes, how would it be possible to get the value into my query?

Any help is very appreciated.

Regards,

Oliver

1 Reply
Highlighted
Creator II
Creator II

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum