There are 3 levels of filtering available in the holidays explorer.
•Use the button to remove the displayed filter permanently.
•Alternatively, you can use the checkbox to disable the filter temporarily.
The number of holidays 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 list of generated holidays in the holidays explorer is done by selecting the holidays set(s) 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.
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 174970, last updated on 22-Nov-2020