Database Tour Documentation Contents Index

Filtering Data

Top Previous Next

Filtering is used to select those data in data set, which satisfy the filter condition (often named simply filter).

To filter query data, use WHERE clause of SQL expression.

To filter the data of an active table, enter the filter condition into the corresponding field (Data page) and turn filtering on by clicking the corresponding button or pressing Enter. If the condition is correct, you will only see the data that satisfy the filter condition in the table grid. To cancel filtering, click the button again.

If filtering is turned on, exporting data to another table will be executed only for those records that satisfy the filter condition.

The last 25 filters are saved for future using.

Autofilling the filter condition

Simple filter condition can be pasted automatically (table must be unfiltered and filter condition field must be empty). Select those field and record in the table, which must be used in filter condition. Then click filter condition field (just above the table).

About filter options, please see Options.

See also

 Filter Examples