TriSys Grid Filtering

 

 

 

 

 

 

 

 

This brief document describes how to use grid filtering in TriSys’ Query and programmable unbound grids.

 

 

 

 

 

 

 

 

 

 

 

Prepared by:

 

 

 

Garry Lowther

Technical Recruitment Industry Systems Ltd

 

Original Draft: February 2002

 

Current Version: Thursday, 21 February 2002

 

 

 

1.      Introduction

 

Grids which are based upon queries or unbound programmed grids have supported column sorting. Script developers have requested that a filtering mechanism be added to these grids to help with the processing of large data sets.

 

This was implemented in February 2002 (build 5.00.113 and above) and this document describes how to use grid filtering.

 

 

 

2.      Enabling Grid Filtering

 

Grid filtering is enabled on all grids which support column sorting i.e.

 

The grid filtering is available from the following menu when right clicking on a column header:

 

 

 

Selecting the Filter… menu option brings up the following dialogue:

 

 

The selected column is displayed in the Field: box, and a list of comparisons is displayed in the drop down combo. The comparison default is Equal and the operators are:

 

 

The search expression is placed into the Value: text box and can contain any text or numbers including wildcards (* or %).

If the underlying field being filtered is a date control, the text box will be replaced by a date combo.

 

When the OK button is pressed (or Return as it is the default button), the filtered column is shown in black with white text to distinguish it from the other columns:

 

 

To filter on another column, right mouse click on it (in this example – AvailabilityDate):

 

 

 

In this case, the date check box has been cleared so that the filter is now on the availability date column and will show all those records where this is null i.e. blank:

 

 

Notice how only the current filter is applied to the grid.

 

By changing the comparison operator to Not Equal and setting the date to null, only those records where availability date is not null are displayted.

 

To clear a filter, use the Clear Filter button.