Filtering tables

The rows shown in a table view can be limited to just those of interest by simple or advanced filtering, defined using functionality just above the table. Saving and reusing sets of table filters is described at the end of this section.

Filtering the rows of a table interactively does not change the underlying content of the table. Some table types have a button allowing the creating of a new table containing only the visible rows.

The Filter on Custom Criteria tool, described in Filter on Custom Criteria, can be used to filter tables non-interactively, generating a new table as a result.

Simple filtering

The default view of a table supports simple filtering, where rows containing a particular search term can be entered into a field to the left of the Filter button (figure 9.2). Simple filtering is enabled when there is an upwards pointing arrow at the top right of the table view. (Click on that arrow reveals advanced filtering options, described later in this section.)

Simple filtering starts automatically, as you type, unless the table has more than 10,000 rows. In that case, click on the Filter button after typing the term to filter for.

The number of rows with a match to the term is reported in the top left of the table.

The following characters have special meanings when used in the simple filtering field:

Image orf_table_simple_filter
Figure 9.2: Filtering for rows that contain the term "neg" using the Filter button

Advanced filtering

Functionality to define sets of filter criteria is revealed by clicking on the downwards-pointing arrow at the top right of the table view, (figure 9.3).

Image open_table_advanced_filtering
Figure 9.3: When the Advanced filter icon is clicked on (top), Advanced filtering fields are revealed (bottom)

Each filter criterion consists of a column name, an operator and a value. Examples are described below.

Filter criteria can be added by:

Filter criteria can be removed by clicking on the (Image close_x_red_16_n_p) icons.

Image add_predefined_table_filter_adv
Figure 9.4: Right-click on a cell value and choose Table filters to reveal predefined criteria that can be added to the list of filters for this table.

Match all and Match any options allow you to specify, respectively, whether all criteria must be met for a row to shown, or whether matching a single criteria is enough for a row to be shown (figure 9.5).

The number of rows with a match to the term is reported in the top left of the table.

Image table_filtering_match_all_any
Figure 9.5: The same two criteria are defined, but with "Match all" selected in the top image, and "Match any" selected in the bottom image.. Six rows out of 169 match all the criteria, while 154 rows match one or both criteria.

Operators available for columns containing text are listed below. Tests for matches are not case specific.

Operators available for columns containing numerical values are:

Number formatting and filter criterion: The number of digits to display after the decimal separator (fractional digits) can be set in the CLC Genomics Workbench Preferences. Thus, there may be more digits in a number stored in a table than are shown in a view of that table. For this reason, we recommend using operators that do not require exact matches, such as =, when filtering on non-integer values.

Saving and reusing table filter sets

Sets of filter criteria defined in the advanced filtering area at the top of a table can be saved for re-use. Filter sets can also be exported and imported, supporting sharing of filter sets with others.

Options for saving and managing filter sets are provided in a menu revealed when you click on the Filter Sets... button (figures 9.6 and 9.8). Saved filter sets are also listed here (figure 9.7). Selecting a saved set from this menu will add those conditions to the top of the table, and apply the filtering.

Saved filter sets can also be applied from the Manage Filters dialog (figure 9.8).

Image table_save_filter_set_named
Figure 9.6: Selecting Save Filters from the menu under the Filter Sets... button (top) opens a dialog showing the filter criteria and prompting for a name for the filter set (bottom).

Image table_reuse_filter_set
Figure 9.7: Saved filter sets are listed at the bottom of the drop-down menu revealed when you click on the Filter Sets... button.

Image table_manage_filter_set
Figure 9.8: Selecting Manage Filters from the menu under the Filter Sets... button (top) opens the Manage Filters dialog, where saved filter sets can be applied to the open table, or deleted. Functionality to export and import filter sets is also provided here (bottom).