Use the Quick Filter pull-down menu (click on the magnifying glass) to choose if the filter should match cells in all columns or just one selected column, case or case insensitive matching, and where in the cell the value must match.įor the Use wild cards option the following characters have special meaning: With a Quick Filter, you can easily list only those rows in the grid that match the entered search string. The Quick Filter acts on the data that is already loaded in the grid, as opposed to a Where Filter which is used to limit the number of rows fetched from the database. This feature is only available in the DbVisualizer Pro edition. Use the Show/Hide Filter Area choice in the Filter menu to toggle the visibility of the inline filter. If you often need to tweak the filter conditions and want a more compact user interface, you can use the inline filter view. You can select column names and sort order from the two lists, and click the Add button to add the sort criteria for the single column to the complete criteria. The Sort area is similar to the Filter area. You can use Ctrl-Enter while editing the value field to reload the grid with that single condition applied, or in the editor to reload the grid based on all filter conditions created so far. Click the Use Filter button to apply the filter, save it and close the dialog, or close the dialog without applying and saving the filter by clicking the Close button.Add the condition to the filter by clicking the AND or OR button, and create additional conditions in the same way if needed,.Select a column name, an operation and the value for the condition using the controls in the Filter area,.Select Open Filter Editor to launch the Filter & Sort Configuration dialog,.You use the Use No Filter choice to disable all filters for the table, and the Clear Filter List to permanently remove all filters for the table. The maximum number of filters to save is specified in the Tool Properties dialog, in the Table Data category under the General tab. The filters are saved between DbVisualizer sessions, and you can toggle between them by selecting them from the menu. The checkbox is selected for the filter that is currently in use. The top entries in the menu are previously used filters for the table, if any. The Filter menu button in the grid toolbar contains all operations related to using a filter. You can use the filter capability in the Data tab to limit the number of rows shown in the grid, using the same syntax as for an SQL WHERE clause. By clicking the blue link, the Data Formats section of Tool Properties will be opened. Note that when a cell is selected, the format pattern used to display the cell value is visible at bottom of the grid. The grid is then sorted on the values in the first column you clicked on (indicated with a 1 next to the arrow), and then all rows with the same value in the first column are sorted on the values in the second sort column (indicated with a 2 next to the arrow), and so on. To sort on more than one column, Ctrl-click (keep the Ctrl key pressed when clicking) on additional columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |