The Filter toolbar lets you specify which entries will be displayed in a table. You can filter the entries in a single column or in all columns, and you can apply consecutive filters.
You can access the Filter Toolbar by right-clicking on a column header and selecting Filter. The toolbar appears at the top of the table or if the table size is too narrow to present the entire toolbar, the toolbar will be opened as a separate window.
Click areas in the window for more information.
- Filter on
- Enter the numeric value or text you want to filter. Clicking the Filter button performs the filter operation. To remove a filter, click Clear.
- Filter in
- This drop-down list lets you choose whether to filter from All columns or only Selected columns. Select All Columns to filter all entries. When Selected columns is chosen, the Select Columns window opens where you can select one or more columns to filter.
-
- Options
- The Options button opens the Options window where you can define the filter to limit the information presented in the table.
-
- Match as string
- When checked, the filter options become String Options and the Filter on field is treated
as a text string to be matched according to the selected String Option. Numbers that appear in the string
are treated as text.
- String Options
- These options determine how text comparisons are performed on the information in the table:
- Match whole word only - Only text strings in the table that match the entire string entered in the Filter on field will be shown in the table.
- Match contains word - Only text strings in the table that contain the string entered in the Filter on field within them will be shown in the table.
- Match does not contain word - Only text strings in the table that do not contain the string entered in the Filter on field within them will be shown in the table.
- Match starts with word - Only text strings in the table that begin with the string entered in the Filter on field will be shown in the table.
- Match ends with word - Only text strings in the table that end with the string entered in the Filter on field will be shown in the table.
- Match as number
- When checked, the filter options become Numeric Options and the Filter on field is treated as a number
to be matched according to the selected Numeric Options. Numbers are treated as a numeric value that can be evaluated
against boolean expressions in the Numeric Options
- Numeric Options
- These options determine how numeric comparisons are performed on the information in the table:
- Match equal to - Only numeric entries in the table that match exactly the value entered in the Filter on field will be shown in the table.
- Match not equal to - Only numeric entries in the table except those that are not equal to the value entered in the Filter on field will be shown in the table.
- Match greater than - Only numeric entries in the table that are greater than the value entered in the Filter on field will be filtered from the table.
- Match greater than or equal to - Only numeric entries in the table that match exactly and are greater than the value entered in the Filter on field will be shown in the table.
- Match less than - Only numeric entries in the table that are less than the value entered in the Filter on field will be filtered from the table.
- Match less than or equal to - Only numeric entries in the table that match exactly and are less than the value entered in the Filter on field will be shown in the table.
- Filter Button
- This button applies the currently defined filter options and column selections to the table.
- Options Button
- This button opens the Options window where you can define the filter to limit the information presented in the table.
For information on related windows:
For information on related tasks:
