Simple Custom Filter

<< Click to Display Table of Contents >>

Navigation:  General Topics > Grids > Filtering >

Simple Custom Filter

Previous pageReturn to chapter overviewNext page

The simple Custom Filter dialog is opened when the (Custom...) option is selected from the Filter drop down list on a grid.

CustomFilterDropDown

The Custom Filter dialog allows you to enter one or two parameters for the filter and the filter is applied to the column it was opened on.

 

Note: Filtering on any text with an apostrophe/single quote marker will not work and will cause an error - e.g. A Hard Day's Night.

 

Using the Custom Filter Dialog on a single column

 

 

Using the Custom Filter Dialog on two columns and using the Filter Drop Down List for two columns

 

 

 

Using the Custom Filter Dialog for a range of dates

 

To filter on dates you need to select one of the filterable date columns.  You can pick a single date or a start and end date.

 

Single Date

Single Date

 

Date Range - All records added between January 31, 2016 and December 31, 2018

Date Range - All records added between
January 31, 2016 and December 31, 2018