LDAP Reader Filter syntax

pro7

• September 13, 2011 00:00

• Answered

Follow

Hi,
Is it possible to enter multiple conditions in a LDAP reader filter??
The user guide says "attribute=value pairs as a filtering condition for the search."
So how do I enter more than one pair? What is the correct syntax?
For example, for testing purposes I only want to read a small subset of records from the LDAP.
Can I filter like this:

objectClass=user
sn="Wilson"

How about something like this:

objectClass=user
employeeID >= 123456
employeeID <= 123477

Do I use semicolon to separate pairs? Or is it more like:

attr1=val1 && (attr2>=val2 || attr3<=val3)

Thanks

• 

  avackova

  • September 14, 2011 12:42

  0

  Comment actions Permalink

  Hello,
  CloverETL uses javax.naming.directory.DirContext.search(String, String, SearchControls) method for searching. It accepts filter expression in RFC 2254 format. So your filters should look as follows:
  

  (&(objectClass=user)(sn=Wilson))

  
  

  (&(attr1=val1)(|(attr2>=val2)(attr3<=val3))) 
  

Please sign in to leave a comment.