Sort and group data
dbForge Transaction Log lets you sort and group data directly in the grid.
Sort data in the grid
You can specify the sort operation, for example, with the help of the ORDER BY clause in a SQL statement or sort data directly in the results grid.
To sort data in the grid or to change the sort order, right-click a column header and select Sort Ascending or Sort Descending.
To assign a secondary sorting, right-click another column header and select Sort Ascending or Sort Descending. You can set as many sorting columns as you need. To stop sorting on a certain column, click it while holding the CTRL key.
To clear column sorting, right-click the column header and select Clear Sorting.
The current sort order of a column is indicated by the sort glyph (a small arrow displayed at the column header’s right edge). If data is sorted in ascending order, the sort glyph represents an up arrow. When sorting in descending order, the sort glyph is displayed as a down arrow. If the column isn’t sorted, the sort glyph is hidden.
Group data in the grid
To group data by column, click 
Show Group by Box on the grid toolbar. The Group by Box area will appear above the data grid, where you can see the grouping order and perform further grouping-related operations. Drag a column header to Group by Box to group the data by that column. You can group the data by multiple columns.
Alternatively, right-click the required column header and select Group By This Column. The data is automatically displayed in groups with collapsed nodes. The column header is moved to the Group By Box area.
You can group data by multiple columns. In this case, the grid will display a tree of nested groups you can expand by clicking the corresponding 
icons. To collapse the groups, click the corresponding 
icons.
To expand or collapse all groups, right-click the Group By Box area and select Full Expand or Full Collapse.
To cancel grouping by a column, drag the column header from the Group By Box area to the grid or right-click the column header and select Ungroup.
To remove all groupings, right-click the Group By Box area and select Clear Grouping from the shortcut menu.