#15793: Add option for an inline grouping and filter options for the Results Grid

alonsomendez reported 2020-05-26T20:42:13Z · last modified 2020-05-26T20:52:44Z

Add option for an inline grouping and filter options for the Results Grid

Dev	tomconrad
QA	Lwaugh

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Grid Results
Version	Future

Would like to request the following options for the Results Grid to be added to the product:

Inline Filtering:

Aqua Data Studio currently has has inline Sorting, but other tools like DBeaver has icons on the column headings, one for filtering and one for sorting. When you click on the Filter button the screenshot below pops up. The list shows a grouped list of all the values in that column. You can then select the filter options and it will filter the Results Pane based on the selection. See attached screenshot for further details.

Inline Grouping:

This is also a feature that other DBeaver has. The Grouping Panel on the right is brought up by clicking on the Grouping Icon on the far-right pane (second icon underneath Panels). It comes up as a blank panel. You can then drag and drop column headings into the Group Panel.

I dragged in the column object_name and it produced the screenshot below. Charts are also possible. See screenshots for further details.