A SQL-like statement that returns a set of records. Use tokens, such as @Request and @Session, inside of the SQL command to control the result set.
The Datalayer.LDAP element uses a SQL dialect.
The most important features are:
SELECT keyword: Specifies a comma-separated list of attributes to retrieve for each object. If you specify *, the query retrieves only the DN of each object.
FROM keyword: Specifies the DN of the base of the search. For example, the DN of the Users container in an Active Directory domain might be 'CN=Users,DC=Fabrikam,DC=COM'. Be aware that the path is enclosed in a pair of single quotation marks (').
SELECT cn, Surname FROM ‘dc=MyDomain,dc=com’ WHERE ObjectClass=’Person’