The grid panels contain a filter control that allow you to refine the displayed results.
The filter allows you to enter a value into the text field that will be used to refine the rows displayed in the grid based on the values stored in a single column, which can be chosen by clicking on the Filter button to the lext of the text field.
Based upon what type of data is stored in each column there are different filters that can be used to refine the rows, for example if a column contains text that the column can be filtered based on matching characters in the text, but if the column contains numbers then the column can be filtered based on the values being less than a particular number.
Text
The filtering for text is case sensetive and is based on wildcards, using * as the wildcard character. If you don’t include the wildcard character in the filter field by default it will be added to the end, so the filtering will only display rows that start with the text entered. If you want to display rows that contain the filter text in the middle then you need to add * to the start and the end, if you want to filter based on the text ending with the filter value then you just add the * at the start. If you don’t want to use a wildcard at all then you need to enclose the filter text in double quotes.
You can also combine two text filter if you want to match multiple values using |
Entered Value | Filter | Matching |
|---|---|---|
WATSON CREEK | WATSON CREEK* | Values that start with “WATSON CREEK” |
WATSON CREEK* | WATSON CREEK* | Values that start with “WATSON CREEK” |
*WATSON CREEK | *WATSON CREEK | Values then end with “WATSON CREEK” |
*WATSON CREEK* | *WATSON CREEK* | Values that contain “WATSON CREEK” |
“WATSON CREEK” | “WATSON CREEK” | Values that are “WATSON CREEK” |
WATSON|FIDDLER | WATSON*|FIDDLER* | Values that start with “WATSON” or “FIDDLER” |
“WATSON”|FIDDLER | “WATSON”|FIDDLER | Values that are “WATSON” or start with “FIDDLER” |
*WATSON|”FIDDLER” | *WASTON|”FIDDLER” | Values that end with “WATSON” or are “FIDDLER” |
Numbers
If you’re filtering a column of numbers then just entering a number will filter the rows that match that value, there is no wildcards like text. If you want to include numbers less than, less than or equal, greater than or greater than or equal then you can preceed the value with <, <=, > or >=, or use <> for not equal.
You can also combine two numeric filters if you want only columns within a range, using a space between the values for and, and a | for or.
Entered Value | Matching |
|---|---|
100 | Values that are 100 |
<100 | Values less than 100 |
<=100 | Values less than or equal to 100 |
>100 | Values greater than 100 |
>=100 | Values greater than or equal to 100 |
<>100 | Values other than 100 |
>100 <200 | Values greater than 100 and less than 200 |
<100 | >200 | Values less than 100 or greater than 200 |
Dates
Date are handled in a similar way to numbers, where entering a value will filter based on that value, but you can also specify range filters. You must also ensure that the date, time or timestamp value used in the filter is entered in a specific format to avoid confusion when parsing the date/time.
Date | yyyyMMdd | Exact day |
yyyyMM | First day of the month | |
yyyy | First day of the year | |
Time | HHmmss | Exact second |
HHmm | Exact second | |
Timestamp | yyyyMMddHHmmss | |
yyyyMMddHHmm | ||
yyyyMMddHH |