You can filter the record list on some grid forms so that only those record lines meeting your selection criteria are displayed. You can set up selection criteria for as many columns as you like. By default all the selection criteria that have been set up are applied together, but this can be modified with selection logic.
What do you want to do?
With the grid form whose records you want to filter displayed, right-click a record line (not the column heading) in the column for which the selection criterion is to be set up.
A drop-down menu is displayed.
Select Filter.
The Filter Form is displayed.
This form is displayed when you select Filter, having right-clicked a record line in the appropriate column in a grid form for which record filtering is available.
Note: When a selection criterion has been set up it remains in place until you either select No filter or click Reset, or close the grid form that is being filtered. Clicking Cancel closes the Filter Form, but a selection criterion set up with it may continue to be applied when filtering operations are carried out, depending on what selection logic is set up.
TEXT BOXES:
The system performs filtering operations by comparing the contents of the upper text box (or in the case of the Range filter, both text boxes) with the contents of the selected column.
TICK BOX:
Inclusive: If the box is ticked, a Range filter displays records whose contents fall within the range specified by the contents of the text boxes; if not, it displays records whose contents fall outside the range.
RADIO BUTTONS:
Equals: Displays all records for which the contents of the selected column match the contents of the upper text box.
Note: For Equals filtering to work properly, the contents of the text box must be in the same case (lower-case or capitals) as is used for the records.
Not equal: Displays all records for which the contents of the selected column do not match the contents of the upper text box.
Note: For Not equal filtering to work properly, the contents of the text box must be in the same case (lower-case or capitals) as is used for the records.
Greater than: Displays all records for which the contents of the selected column are alphabetically higher than the contents of the upper text box (for example, with WI in the box, records beginning with WINCH would be displayed, but those beginning with WHEEL would not).
Note: For Greater than filtering to work properly, the contents of the text box must be in the same case (lower-case or capitals) as is used for the records. Because of the sorting conventions, digits are treated as alphabetically lower than letters.
Less than: Displays all records for which the contents of the selected column are alphabetically lower than the contents of the upper text box (for example, with AC in the box, records beginning with ABS would be displayed, but those beginning with ACCUMULATOR would not).
Note: For Less than filtering to work properly, the contents of the text box must be in the same case (lower-case or capitals) as is used for the records. Because of the sorting conventions, digits are treated as alphabetically lower than letters.
Contains: Displays all records for which the contents of the selected column contain a text character string matching the contents of the upper text box (for example, entering either CROSS or 2 in the box would display a list containing the record CROSS MEMBER ENGINE 2).
Note: For Contains filtering to work properly, the contents of the text box must be in the same case (lower-case or capitals) as is used for the records.
Range: Displays all records for which the contents of the selected column contain a text character string which is alphabetically equal to or between the contents of the two text boxes (for example, with J in the upper box and K in the lower, all records beginning with J would be displayed).
Note: For Range filtering to work properly, the contents of the text boxes must be in the same case (lower-case or capitals) as is used for the records. If the Inclusive check-box is not ticked, only records falling outside the range will be displayed (for example, with B in the upper box, Z in the lower box and Inclusive not ticked, only records beginning with A or a digit would be displayed).
See sorting conventions.No filter: No filtering on the selected column is applied.
Buttons:
Reset: Activates No filter and empties the text boxes
Cancel: Closes the Filter Form, but leaves any selection criterion set up with it still active
With the grid form whose records you want to filter displayed, left-click the column heading (not a record line) in any column.
The grid form's columns are given the labels A, B, C and so on, and the Selection Criteria Form is displayed.
This form is displayed when you left-click a column heading in a grid form for which record filtering is available.
TEXT BOX:
Enter in the text box the selection logic you want to apply to the grid form, using the appropriate capital letter for the column reference, the ampersand (&) for and and the oblique stroke (/) for or. For example:
A&B: Selects records meeting both column A's criterion and column B's
A/B: Selects records meeting either column A's criterion or column B's
(A&B)/C: Selects records meeting either column A's and column B's criteria together, or column C's
Note: When you amend selection logic, you must click Refresh on the grid form to display the re-filtered records.
For sorting purposes digits are treated as coming after the end of the alphabet, with lower values. The full sequence in DESCENDING order is Z, Y, X ... A, 9, 8, 7 ... 0. So a record beginning with any letter is treated as greater than one beginning with any number, and a record beginning with any number is treated as less than one beginning with any letter.
This means that you can select all the records beginning with an alpha character by selecting those greater than 9, or all the records beginning with a numeric character by selecting those less than A.
