The Filter Selection Tool

This tool allows the user to create a floating selection list of records that can change the selected records in the main window.

Creating a Selection List

Assuming there is already a database open to open the filter window click on the = (equals) button in the toolbar. In this example, we are going to be using an example table found under C:\SIMPOL\projects\tests\calcevaltest\bin it contains a large selection of spices and some relevant purchasing information.

In this example, we are going to see all the records that have a tax of 5.50 or lower: ORDERDTL."Tax Rate" <= 5.5. Next, we need to select which columns we want to be shown.

It will then run the query and start filling out the grid. The records are placed in sorted order into the grid.

Tip
Hovering over the Filter label in the lower right corner will show a tooltip with the full filter in case it is too large to be visible in the dialogue window title bar.

Selection List Sort Order

The sort order for the resulting recordset cannot be changed, it is sorted in the index order that was selected when the process started. If you want to change the index order you have to close the current filter and open a new one but before filtering it is necessary to select a different sort order in the index drop-down menu in the toolbar (see below).