Online Documentation for SQL Administrator for SQL Server

Filter Builder dialog

The Filter Builder dialog is a powerful filtering tool. In this dialog you can set as much conditions as you need.

It is aimed at facilitating the procedure of creating and applying complex filter criteria for data.

To open the Filter Builder dialog, use the Filter Editor item of the grid heading context menu.

Condition consists of Column, Logical operator and Value. Press any of these elements to change its value.

Two or more conditions form Condition group. Its popup menu allows you to change relations between child conditions ( And, Or, Not And, Not Or), to Add Condition or Condition Group or to Remove Group. For root condition group the Clear All operation is also available.

Note: You can use the Insert keyboard button to add a condition to the selected group and the Delete button to clear the filter.