PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • LDAP filter
  • Examples of filters
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
LDAPFind (Function)
In French: LDAPRecherche
Performs a search in an LDAP server. The search is performed recursively. You also have the ability to use LDAPListChildren.
Example
// All the names starting with s and w
sCriterion1 is string = "(|(displayname=s*)(displayname=w*))"

// All the names that sound like kurd
sCriterion2 is string = "(displayname~=kurd)"

// All the names with a givenname except Mark
sCriterion3 is string = "(&(givenname=*)(!givenname=Mark))"

sSearchResult = LDAPFind("MySession", WIN_FirstWin.EDT_DNBASE, sCriterion1)
gsListSearch += sSearchResult + CR

sSearchResult = LDAPFind("MySession", WIN_FirstWin.EDT_DNBASE, sCriterion2)
gsListSearch += sSearchResult + CR

sSearchResult = LDAPFind("MySession", WIN_FirstWin.EDT_DNBASE, sCriterion3)
gsListSearch += sSearchResult + CR
Syntax
<Result> = LDAPFind(<Session Name> , <DN of Base Object> , <Search Criterion>)
<Result>: Character string
  • List of distinguished names (DN) for the objects found. The different elements are separated by "CR" characters (Carriage Return).
  • Empty string ("") if no object corresponding to the search was found.
    If an error occurs, <Result> corresponds to an empty string ("") and the ErrorOccurred variable is set to True. ErrorInfo returns more details about the error.
<Session Name>: Character string (with quotes)
Name of LDAP session used.
<DN of Base Object>: Character string (with quotes)
Distinguished Name (DN) of object from which the search is performed.
<Search Criterion>: Character string (with quotes)
LDAP filter that will be applied to the search. See remarks for more details.
Remarks

LDAP filter

The search filter uses the syntax of LDAP search filters. These filters can use one of the following syntaxes:
  • (<Attribute><Operator><Value>)
  • (<Operator><Filter1><Filter2>)
In these syntaxes:
  • <Attribute> corresponds to the name of an LDAP attribute.
  • <Operator> can take one of the following values:
    • =: Equality
    • ~=: Approximation
    • <=: Less than or equal to
    • >=: Greater than or equal to
    • &: AND
    • |: OR
    • !: NO
  • <Value> corresponds to the sought value. The "*" character is allowed.
    If specific characters must be used in the search filter, these characters must be replaced by the corresponding sequence:
    • Character *: \2a
    • Character (: \28
    • Character ): \29
    • Character \: \5c
    • Character NULL: \00
    • Character /: \2f
  • <Filter1> is a filter in the following format: (<Attribute><Operator><Value>)
  • <Filter2> is a filter in the following format: (<Attribute><Operator><Value>)

Examples of filters

"(objectClass=*)"Filters all the objects
"(&(objectCategory=person)(objectClass=user)(!cn=andy))"Filters all the users except "andy"
"(sn=sm*)"Filters the objects whose 'sn' starts with 'sm'
"(&(objectCategory=person)(objectClass=contact)(|(sn=Smith)(sn=Johnson)))"Filters all the contacts whose 'sn' is 'Smith' or 'Johnson'
Components
WINDEVWEBDEV - Server codeReports and Queries wd230com.dll
See also
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment