Online Documentation for SQL Query for SQL Server

Filtering records


A number of filtering facilities is implemented in the grid for your convenience. You can filter records in the grid in either of the following ways:

 

  • click the arrow-down button next to the column caption to display the drop-down list and select any of the column values to filter records by this value of the selected column

or

  • click the arrow-down button next to the column caption to display the drop-down list, then select the Custom item and build a simple filter using the Custom Filter dialog

or

  • use the btnSetFilter Set filter button on the navigation pane to invoke the Filter Builder dialog and create a composite filter using the dialog.

 

hs3422 - Filtering records

 

After the filter is set, the gray filtering panel becomes visible at the bottom of the grid. This panel allows you to see the active filtering condition and easily enable or disable it using the checkbox on the left. If necessary, you can click the Customize... button on the right to customize your filter and add more complicated filtering conditions within the Filter Builder dialog.