Operators

An operator is a word or phrase (equals, greater than, contains) that provides the necessary information for two values to produce an output.

The availability of operators depends on the type of values you choose for a Search Clause.

Operator drop-downs appear in CSM when creating a Comparison Clause.

Operators include:

• Equals: Finds records where value in field equals value in far right drop-down list.
• Not equal: Finds records where value in field does not equal value in far right drop-down list.
• Like: Finds records where the value matches the value and its wildcard in the right-most drop-down. (example: Jo% will find Joe, John, etc.).

  Use % as the wildcard character. For example, enter John% to find all records where the field starts with "John." Do not use the wildcard character at the beginning of the string if it can be avoided (example: %SON), because the underlying database query will be very slow.

• Not like: Finds all records that do not match a value and its wildcard.
• Empty: Finds all records where the field value is empty.
• Not empty: Finds all records where the field value is not empty.
• Greater than: Finds all records where the value is greater than the value in the far right drop-down list.
• Greater or equal: Finds all records where the value is greater than or equal to the value in the far right drop-down list.
• Less than: Finds all records where the value is less than the value in the far right drop-down list.
• Less or equal: Finds all records where the value is less than or equal to the value in the far right drop-down list.
• Contains: Does a SQL Server Full-Text search to find records that contain the text in the far right drop-down list.

  You can also use the All Words/Any Words option.

• Is member of team: Use to determine if a particular user's ID is a member of a particular Team's ID.
• Is not member of team: Use to determine if a particular user's ID is not a member of a particular Team's ID.