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).