Smart Note LDAP query for InfoSet?

 5 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
George Graham
Veteran Member Send Private Message
Posts: 201
Veteran Member
Does anyone have a good example they can share of an LDAP query from Lawson's LDAP that was used to build an info set? Trying to build a dataset of users and emails to utilize for bursting....All queries I'm trying come back with no data....
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
I actually added a screen shot of a query I created in LDAP sometime back. I think it is in the same forum.

We actually append the "@blank.com" to the id of the employee to get an employee email and then burst the smart notes. The id of an employee if captured is tored in the paemployee table in Hr. we also store employee emails in the email field in the employee table in HR if your org maintains it.

This is how we use email addresses to burst.
George Graham
Veteran Member Send Private Message
Posts: 201
Veteran Member
Don't have the luxury of going to the database....

I can actually get some data with (objectclass=*) or even something like (objectclass=zzlwsnobjPeople). But it's only bringing back the standard attributes (CN, distinguishedName,whenCreated, etc...). It does not bring back any of the zzlwsn attributes - and I can't seem to find a way to list those specifically in the query to get it to return them....
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
For an LDAP query you cannot specify certain fields. When it comes to the 2nd step that's when you specify the exact field name and mark it as a string.

The field that has the email address is :

 zzlwsnattrEmail
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
i forgot to metion we are on LS9 security.
George Graham
Veteran Member Send Private Message
Posts: 201
Veteran Member
Figured that out about the same time you posted back. Thanks!! Got it working now...