Manage search results

Last modified: October 1, 2024

This topic discusses how you can manage search results.

Sort and Filter Search Results

dbForge Studio allows you to quickly sort search results. You can sort records in each column by ascending or descending alphabetic order by clicking a column heading.

To apply filter to a column:

1. Hover a cursor over a column heading. The Filter button filer-button will appear its upper right corner.

   

2. Click the Filter button and select an item from the drop-down list. All the records corresponding to this item will be displayed in the grid.

3. Optionally, select the “Custom” option from the drop-down list. The Custom AutoFilter window will appear, where you can fine tune the filter.

   

4. The filters currently applied to the search results may be edited in the Filter Editor. To evoke the editor, click the Edit Filter button in the lower right corner of the Search Results grid.

   

Find Object in Database Explorer

dbForge Studio can navigate you to an object in the Database Explorer directly from the Search window.

1. Double-click the object in the Test Results grid; or
2. Right-click the object in the Test Results grid and select Find in Database Explorer from the context menu;
3. Select the object in the Test Results grid and click the Find in Database Explorer button below the grid.

Word Wrap

Click the Word Wrap button to set and clear the Word Wrap option for source code displayed in the Preview window. When the option is enabled, all the text shall fit the current width of the Preview window.

Line Numbers

Click the Show line numbers button to set or clear numbers for lines of the source code displayed in the Preview window.

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!