How to use "IN" operator from SQL for writing LDAP query

Question

I want to use "IN" operator from SQL for writing LDAP query.

For ex: If I have a list of names called "NameList", I write the following SQL query

SELECT * FROM TABLENAME WHERE NAME IN "NameList"

How do I do write similar LDAP Query?

public static final String[] LDAP_ATTRIBUTE_IDS = {"displayName"};

LdapContext ldapContext = new InitialLdapContext(env, null); \\env has all 
 \\connection details

List NameList = new ArrayList<String>();
NameList.add("ABC");
NameList.add("XYZ");
NameList.add("LMN");

NamingEnumeration namingEnumeration = ldapContext.search("",
"(&(objectCategory=person)(objectclass=user)(|(sAMAccountName=XYZ)(sAMAccountName=LMN)(sAMAccountName=ABC)))", getSearchControls());

Attributes attrs = ((SearchResult) namingEnumeration.next()).getAttributes();
String value = attrs.get(LDAP_ATTRIBUTE_IDS);

Instead on adding XYZ,LMN and ABC using "|" operator I would Like to know if NameList can be used with "IN" operator.

Gabriel Luci · Accepted Answer · 2019-07-23 13:31:08Z

3

No, there is no equivalent IN operator for searching LDAP.

Maybe you're not using Active Directory, but AD does support an SQL Dialect for searching, but even then, it doesn't support IN.

So the only way to do this is the way you already are. If you have your NameList array, you can use String.join to build the query. Something like this:

NamingEnumeration namingEnumeration = ldapContext.search("",
"(&(objectCategory=person)(objectclass=user)(|(sAMAccountName=" + String.join(")(sAMAccountName=", NameList) + ")))", getSearchControls());

answered Jul 23, 2019 at 13:31

Gabriel Luci

41.5k4 gold badges66 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use "IN" operator from SQL for writing LDAP query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related