DataLayer.LDAP - LDAP Query Syntax for Java
The LDAP syntax supported in Logi products for Java applications is similar to that of SQL. The basic keywords are:
Specifies a comma-separated list of attributes to be retrieved for each object and can include "*" to retrieve all attributes. All other "column" operations of the type found in SQL queries (functions, AS, expressions, etc.) are not available.
Specifies the scope of the search. Values can include:
objectScope; - a search of the base object only|
oneLevelScope; - a search of objects immediately subordinate to the base object, but not the base object subTreeScope; - a search of the base object and its entire subtree Scope values must end with a semi-colon. The base DN of the object of the search is configured in the Connection.LDAP element's Base DN attribute.
Specifies search filter expressions and multiple expressions may be strung together using AND and OR. Expressions only support these basic operators:
~= Approximately equal to
<= Lexicographically less than or equal to
>= Lexicographically greater than or equal to
Expression comparison values are enclosed within a pair of single quotation marks (').
Query example (also see .NET examples above, which only differ in regard to the FROM clause): SELECT cn FROM subTreeScope; WHERE objectClass = 'groupOfUniqueNames' AND uniqueMember = '*uid=@Request.rdUsername~*' As shown in the example, you may use tokens, such as @Request and @Session, inside of the LDAP query to control the result set. Attribute values are stored with case intact in LDAP structures, but searches against them are case-insensitive by default. Certain attributes (like password) may be case-sensitive when searching
Please sign in to leave a comment.