PowerExchange for LDAP User Guide for PowerCenter

Back Next

Operators

The following table describes the operators that you can use in a filter condition:

Operator	Description
=	Extracts data where value of a field is equal to the specified value. For example, (cn=Directory Administrators)
<=	Extracts data where value of a field is lesser than or equal to the specified value. For example, (roomNumber<=2200)
>=	Extracts data where value of a field is greater than or equal to the specified value. For example, (roomNumber>=2000)
!	Extracts data where value of a field is not equal to the specified value. For example, (!(roomNumber=2290))
\|	Extracts data where value of a field is equal to any one of the specified values. For example, (\|(cn=Anne-Louise)(cn=Andy Bergin))
*	Extracts data that contains the specified value. Filter condition as a prefix. For example, enter (ou=Special) to display the data that begins with Special. Filter condition as a suffix. For example, enter (ou=ISV) to display the data that ends with ISV. Filter condition as a substring. For example, enter(objectClass=Org) to display the data that contains Org.
&	Extracts data where value of a field is equal to all the specified values. For example, (&(roomNumber=2000)(roomNumber=3000))