Tables contain thousands of fields of data. To retrieve only the specific data that you need for conversion, you define filters for tables.
Choose a table for which you want to define a filter and click "Filter" button.
"Filter" window consists of three parts:
1."New condition" - here you can select one or multiple filters on a query.
To create a filter, you need to specify three elements:
- Choose a table field for which you want to retrieve data
- Choose the possible filter operations (not null, equal to, less than etc.)
- Choose filter value
After defining the necessary information, click the "Add condition" button.
2."Selected conditions" part reflects the list of all defined filters specified above.
If you want to delete any conditions, please select the condition you want to delete and press "Remove condition" button.
3. To display selected data, click "Refresh" button on the "Preview" GroupBox and you will see a preview of all the filters effects.
You can preview the effect of all the filters automatically when pressing the "Add condition" button if you check the corresponding check box.
The "Query" pane displays your filter in the form of the SQL query. If you change your query, the "Query" pane automatically updates and reformats.
NOTE: If you do not select any conditions, all rows will be converted.
Possibly, some errors may appear during filter building.