The following are search type options available when searching on a column. You can access the search type option drop-down list by single-clicking under on the icon on the left side of the field under the column. The following options are available.
|
Option |
Description |
|---|---|
|
Equals |
Displays all items that exactly match the value provided. |
|
Not equals |
Displays all items that do not match the value provided. |
|
Less than |
Displays all items with values less than the value provided. |
|
Less than or equal to |
Displays all items with values less than or equal to the value provided. |
|
Greater than |
Displays all items with values greater than the value provided. |
|
Greater than or equal to |
Displays all items with values greater than or equal to the value provided. |
|
Contains |
Displays all items that contain the value provided. |
|
Does not contain |
Complement of Contains. |
|
Like (wildcards) |
Displays matching items when the value provided contains wildcards (* and ?). |
|
Not like (wildcards) |
Complement of Like. |
|
Match (regular expression) |
Displays all items matching the value provided, where the value provided is a regular expression. A regular expression is a specially formatted search string that uses symbols to represent complex matching patterns. For example, a vertical bar (|) can be used to separate alternatives. The string failed|error would return all rows containing either failed or error. For information about regular expressions, consult a programming reference guide. |
|
Does not match (regular expression) |
Complement of Matches Regular Expression. |
|
Starts with |
Displays all items that start with the value provided. |
|
Does not start with |
Complement of Starts with. |
|
Ends with |
Displays all items that end with the value provided. |
|
Does not end with |
Complement of Ends with. |