Is

Displays all values for the selected field that equal the value specified.

NOTE: You cannot separate values by comma. If required, use one of the operators:

• Any of the following
• None of the following

Is not

Displays all values for the selected field that do not equal the value specified.

NOTE: You cannot separate values by comma. If required, use one of the operators:

• Any of the following
• None of the following

Any of the following

Displays all values that are any of the listed values. You can specify more than one value, or set a relationship between the values (substring of *)

None of the following

Displays all values except the listed values. The relationship between the values is and. (substring *)

Like

Displays all values that are a substring of the listed value. (app*)

You can use any of the following:

• <character>: Finds the value of the character. For example, a searches for the value a.
• <character>*: Finds any value that starts with the character. For example, a* searches for any values that starts with a.
• *<character>: Finds any value that ends with the character. For example, *a searches for any value that ends with a.
• *or*: Finds any value that that has or in any position.

NOTE: You cannot separate values by comma. If required, use one of the operators:

• Any of the following
• None of the following

Not like

Displays all values that are not like the substring of the listed value. (app*)

You can use any of the following:

• <character>: Ignores the value of the character. For example, a ignores the value a.
• <character>*: Ignores any value that starts with the character. For example a* ignores any values that starts with a.

  *<character>: Ignores any value that ends with the character. For example *a ignores any value that ends with a.

• *or*: Ignores any value that that has or in any position.
• Any of the following

  NOTE: List of possible values are separated by comma. Accepts asterisk.

• None of the following

  NOTE: List of possible values are separated by comma. Accepts asterisk.

Greater than

Displays all values that are numerically greater than the listed value.

Greater than/Equals

Displays all values that are numerically equal to or greater than the listed value.

Lesser than

Displays all values that are numerically lesser than the listed value.

Lesser than/Equals

Displays all values that are numerically equal to or lesser than the listed value.