Online Documentation for SQL Manager for DB2

Filter Builder dialog

The Filter Builder dialog is a powerful filtering tool implemented in Data View for your convenience.

The dialog is aimed at facilitating the procedure of creating and applying complex filter criteria for data. In addition, the tool allows you to save filter criteria to an external *.flt file for future use.

To open the Filter Builder dialog, use the Set filter button on the navigation panel available within the Data tab of Table Editor and the Result(s) tabs of SQL Editor and Query Builder.

• Invoking the Filter Builder dialog
• Adding a new condition to the filter
• Setting filter criteria
• Setting filter operator
• Setting filter criteria values
• Adding a new group
• Setting group operator
• Applying filter conditions