Exportizer Users' Guide vlsoftware.net

Filtering Data

Contents Index Previous Next

You can prepare source data for copying / exporting by filtering the source data.

To filter the data in open table, enter the filter condition in Filter window and press ENTER or click the corresponding check box to the right. When a field name, used in the filter condition, contains spaces, you must enclose it in brackets.

The last 25 filters are stored and available for reusing.

Examples of filters:

1. CustNo > 1000

2. FirstName = 'Ivan' or FirstName = 'Todd'

3. [Payment sum] > 20 and [Payment sum] < 87 and PayCode = 2

Note: To filter the SQL query result (available only in Exportizer Pro), it is better to use WHERE clause of SQL query instead of applying the filter in the way described above.