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
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
    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
      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
        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
          Posts: 412
          Veteran Member
            i forgot to metion we are on LS9 security.
            George Graham
            Veteran Member
            Posts: 201
            Veteran Member
              Figured that out about the same time you posted back. Thanks!! Got it working now...