Asides from browsing through all records of a table it is generally useful to inspect a subset of the table data, restricted by certain conditions. In the selection setup dialog you can create as many selection conditions you like by interactively defining the fields, operators and values you ant to compare against.
The topmost selection popup menu allows you to select between a selection, create a new selection, rename one or delete it completely.
Once you have choosen a selection, you can assign as many field conditions as you like through the field conditions.
For every condition you must define the field name, choose one of the given operators and provide a value to test against. Only if you have more than one field condition, then connector between the conditions will be relevant in that it defines the logical way to combine these conditions.
The SQL-Preview displays the conditional statement DocCleaner generates from you condition list.
Example
You may want to look for a particular area in your international adress table defined by zip code and language. That said you should create three conditions in a selection: one checks for the language of a record, the second and third conditions check for a certain range in the zip field.
|