To create a new filter: Select Open Filter Editor to launch the Filter Sort Configuration dialog, Select a column name, an operation and the value for the condition using the controls in the Filter area, Add the condition to the filter by clicking the AND or OR button, and create additional conditions in the same way if needed, 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.A tables data can be viewed in in various ways in the Data tab in its Object View tab.
Check Editing Table Data for information about the table data editor in DbVisualizer. Opening the Data tab To open the Data tab for a table: Locate the table in the Databases tab tree, Double-click the table node to open its Object View tab, Open the Data sub tab. Each column width is automatically resized to match the column width, including the column header, by default. You can disable this behavior in the the Tool Properties dialog, in the Grid category under the General tab. If Auto Resize Column Widths is enabled, the Max Column Width setting can be used to limit the column width so that an extremely wide column does not take up all space. In the same Tool Properties category, you can also disable Show Grid Row Header, i.e. Dbvisualizer Pro Free Edition AndData tab in the DbVisualizer Free edition and result sets from joined tables. The column headers corresponds to the column names by default, but you can specify in the Tool Properties dialog, in the Grid category under the General tab, that you like to use the column alias instead. This is mostly useful for grids representing SQL Commander result sets, but may also be useful in the Data tab grid for some databases. The Data tab contains a number of features for locating and focusing on just the data of interest as described in the following sections. Formatting Note that when a cell is selected any format pattern used, to display the cell value is visible at bottom of the grid. By clicking the blue link the Data Formats section of Tool Properties will be opened. Sorting You can sort the data grid based on the values in one or more columns: Click on a column header to sort the grid in ascending order on the values in that column, indicated by an up-arrow in the column header. Click the same column header again to sort in descending order, indicated by a down-arrow in the column header. Click a third time to show the data in the order it was received from the database. To sort on more than one column, Ctrl-click (keep the Ctrl key pressed when clicking) on additional columns. 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. Where 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. The Filter menu button in the grid toolbar contains all operations related to using a filter. The top entries in the menu are previously used filters for the table, if any. ![]() The filters are saved between DbVisualizer sessions, and you can toggle between them by selecting them from the menu. The maximum number of filters to save is specified in the Tool Properties dialog, in the Table Data category under the General tab. 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |