Online Documentation for SQL Manager for MySQL
Filtering records
A number of filtering facilities are implemented in the grid for your convenience. You can filter records in the grid in either of the following ways:
- right-click a row and select the Quick Filter context menu item to filter records by the current value of the selected column;
- 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;
- use the Set filter button on the navigation pane to invoke the Filter Builder dialog and create a composite filter using the dialog.
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. The Arrow-down button opens the drop-down menu which allows you to browse the filter history for this dataset.
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.
To remove the current filter, click the Close button.