EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

Filtering


It is possible to make quick filtering by a specific value, or by blank/non blank field criteria.

To activate quick filter press the button in the upper-right corner of the column header like at the screenshot below.

 

Custom Filter

 

 

To apply manually defined conditions use the Custom item of the drop-down list.

 

Custom Auto Filter

 

 

Pick the logical expression from the lists on the left and define values in the fields on the right. Use the '_' character to represent any single symbol, and use the '%' character to represent any series of symbols in the condition string. Relation between these conditions is defined with RadioButton And/RadioButton Or options.

 

 

For more complex filtering use the Filter Builder. In this dialog you can set as much conditions as you need.

 

To launch the builder use the btnFilterEditor Filter Editor item of the column header popup menu.

 

Filter Builder

 

 

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

 

Two or more conditions form Condition group. Its popup menu allows you to change relations between child conditions (And_1 And, Or Or,NotAnd Not And, NotOr Not Or), to AddCondition Add Condition or AddGroup Condition Group or to RemoveGroup Remove Group. For root condition group the ClearAll 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 filter.

 

When any filter is applied the grey panel appears in the bottom of the grid.

 

Filter History

 

 

Flag control enables/disables filtering. The arrow-down button opens the list containing recently applied filters.

To open current filter expression in the Filter Builder press the Edit Filter button.

The btnClose Close button disables panel and cancels filtering.