Filtering in the Advanced Data Grid

Navigation:  Appendices > Common UI Elements > Advanced Data Grid >

Filtering in the Advanced Data Grid

Previous pageReturn to chapter overviewNext page

There are 3 levels of filtering available in advanced data grids.


Whichever filtering method you use, the currently applied filter will be displayed at the bottom 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.


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


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.


Intermediate Filtering


Intermediate filtering is done by using the filter row at the top of the holidays explorer, as shown below.



Filtering with Presets


Filtering using the filter row can be done using the preset values of the database of generated holidays, by clicking on the small funnel icon which appears at the top of each column, if you move your mouse over it. You are then presented with a list of all the unique values taken by that column/field, as shown in the example, below left. You can then select one or more of these values as filter.


Filtering with Free Values


Alternatively, you can use free text with one of the built-in filter operators, such as contains, begins with, like, ...., as shown in the image above right. If you use the like operator, then the wildcard character is the percentage sign %.

Topic 176995 updated on 20-Feb-2019.
Topic URL: