Report Filter Operators
Table: Report filter operators
Operator | Description |
|---|---|
equals1 | Filters rows where the value of the associated column is equal to the value entered. The column can be of the type Number, Date or String. |
not equal1 | Filters rows where the value of the associated column is not equal to the value entered. The column can be of the type Number, Date or String. |
greater than | Filters rows where the value of the associated column is greater to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
less than | Filters rows where the value of the associated column is smaller than the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
greater than or equal to | Filters rows where the value of the associated column is greater than or equal to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
less than or equal to | Filters rows where the value of the associated column is smaller than or equal to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
contains1 | Filters rows where the value entered is present anywhere in the value of the associated column. Example: If the column value is "rattle" and the value entered is "rat" or "at" the row will be displayed. The column can only be of the type String. |
does not contain1 | Filters rows where the value entered is not present anywhere in the value of the associated column. The column only can be of the type String. |
is a member of | Filters rows where the value of the associated column is equal to any of the comma-separated values entered. There is no limit to the number of characters that can be entered for this value. The column can be of the type Number, String, Duration, and File Size. Example: If you enter a value of chair, table, desk and the column value is table, the row will be displayed. |
is not a member of | Filters rows where the value of the associated column is not equal to any of the comma-separated values entered. There is no limit to the number of characters that can be entered for this value. The column can be of the type Number, String, Duration, and File Size. |
matches regular expression | Filters rows where the value of associated column matches the regular expression2 entered. The column can only be of the type String. For example, to find a column starting with , use or |
does not match regular expression | Filters rows where the value of associated column does not match the regular expression2 entered. The column can only be of the type String. |
1 -is case insensitive.
2 -reference: http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html