Setting a Filter for Records

This section describes how to filter the records in the set database.
Setting a Filter
Disabling a Filter

Setting a Filter

1.
Select the [Database] menu > [Database Connection/Settings].
The [Database Connection/Settings] dialog box is displayed.
2.
Select the [Set filters for filtering records] check box, and click [Filter Settings].
The [Filter Settings] dialog box is displayed.
3.
Use three pull-down menus and one text box to specify the filtering conditions.
Select the field to filter from the [Fields] pull-down menu. The items that can be selected differ according to the set database.
Select the filtering conditions in the [Condition] pull-down menu. The following items can be selected.
[Equals]
Extracts items that equal the specified keyword(s).
[Does Not Equal]
Extracts items that do not equal the specified keyword(s).
[Contains]
Extracts items that contain the specified keyword(s).
[Is Less Than]
Searches for items that contain a smaller value than the specified keyword(s).
[Is Greater Than]
Searches for items that contain a larger value than the specified keyword(s).
[Is Less Than or Equal To]
Searches for items that contain a value below the specified keyword(s).
[Is Greater Than or Equal To]
Searches for items that contain a value above the specified keyword(s).
Enter a keyword/value in the [Value] text box.
In the pull-down menu on the left, specify the relationship between the conditions when multiple conditions are specified.
Note
You can configure up to 5 filtering conditions.
4.
Click [OK].
The [Database Connection/Settings] dialog box is displayed again and the filtering results are displayed.
Important
By setting a filter when variable printing in Document Binder, only the records extracted by the filter become print targets. If you want all records to be print targets, remove the filters.
Note
Clicking [Clear All] clears the filtering conditions.

Disabling a Filter

To disable a set filter, perform the following.
1.
Select the [Database] menu > [Database Connection/Settings].
The [Database Connection/Settings] dialog box is displayed.
2.
Click [Filter Settings].
3.
Click [Clear All] > [OK].
The [Database Connection/Settings] dialog box is displayed again and all the records are displayed.
Note
Or, deselect [Set filters for filtering records] in the [Database Connection/Settings] dialog box to remove the filters.