There are 3 levels of filtering available in advanced data grids.
current filter sumary at the bottom left of advanced data grids
Whichever filtering method you use, the currently applied filter will be displayed at the bottom left of the data grid, as shown in the image on the right.
•Use the button to remove the displayed filter permanently.
•Alternatively, you can use the checkbox to disable the filter temporarily.
•Finally, if you move your mouse near any of the individual conditions of the filter, then that condition appears surrounded by a dashed red frame, and you can delete that specific condition only, as shown in the image on the right.
The number of elements displayed as a result of any combination of basic, intermediate or advanced filtering is always shown at the bottom of the list of holidays, as shown in the image above.
Note that grouping often achieves the same results as some of the more complex filtering, and is more intuitive for most users.
Basic filtering of the data in an advanced data grid with a treview on the left, is done by selecting the data elements you want to include, using the TreeView hierarchical control on the left of the holidays explorer, as shown in the example on the right.
While somewhat limited, this method has the advantage of being intuitive.
the filter row
You can filter using the filter row, located at the top of advanced data grids, as shown on the right.
Filtering using the filter row is done by typing some text, in one or more of the columns, and selecting one of the built-in filter operators, such as contains, begins with, like, ...., as shown in the image on the left below (if you use the like operator, then the wild-card character is the percentage sign %).
Another option is to filter using preset values, which the advanced data grid extracts automatically from the underlying displayed data, as shown in the example above right. Clicking on the small funnel icon which appears at the top of each column, as you move your mouse over it, and you are then presented with a list of all the unique values taken by that column/field, as shown in the example, below right. You can then select one or more of these values as filter.
Its first tab, Values, contains a list of all the preset values, automatically extracted from the underlying displayed data, but, in addition, it is possible to filter that list of presets by entering some partial text, as shown in the example below left.
The second tab contains a set of filters specific to the type of data of the current column, as shown in the example above right, for a column containing dates.
Topic 176995, last updated on 27-Nov-2020