Advanced filter operators
Select from the following operators:
Table: Advance filter operators
Operator | Description |
|---|---|
equals | The result value is equal to the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
not equal | The result value is not equal to the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
greater than | The result value is greater than the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
less than | The result value is less than the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
greater than or equal to | The result value is greater than or equal to the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
less than or equal to | The result value is smaller than or equal to the value entered. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
contains | The value of the entry is present anywhere in the value of the result. Example: If the entry is "rattle" and the value entered is "rat" or "at" will be displayed. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
does not contain | The value entered is not present anywhere in the value of the result. The entry can be a number, date, string or a blank. The match is case insensitive. Date entry format is based on your locale and the settings in your profile. To set the value as a blank, you must select an operator. |
is a member of | The result value is equal to any of the comma-separated values entered. This string of values is the equivalent to a multi-select. There is no limit to the number of characters that can be entered for this value. The entry can be numbers and strings. To set the value as a blank, you must select an operator. |
is not a member of | The result value is not equal to any of the comma-separated values entered. This string of values is the equivalent to a multi-select. There is no limit to the number of characters that can be entered for this value. The entry can be numbers and strings. To set the value as a blank, you must select an operator. |
matches regular expression | The result value matches the regular expression entered. The entry can only be a string. See also: http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html For example: To find all hosts that start with qa_, use ^qa_.* |
does not match regular expression | The result value does not match the regular expression entered. The entry can only be a string. See also: http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html |