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

To filter SQL query result, use WHERE clause of the SQL command. Here, the table filtering is described.

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

The last used table filters are saved for future using.

When exporting, copying or reporting filtered dataset, only filtered data will processed.

Auto-filling the table filter condition

Simple filter condition for tables can be created automatically. Table must be unfiltered and filter condition field must be empty. Select a table grid cell, 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