[Feature request] Grouping of records grid view

[neut]

It would be nice to have the option to group the records as shown in the data tab of sql Views or Tables. This makes live sorting and browsing through data much easier. Example implementation is by sqlitemaestro application (ability to expand/collapse groups, as well as nested groups), although I think the UI of sqlitestudio is overall much better and faster.

Thanks overall; great app.

[pawelsalawa]

I don't know what would this grouping look like or how it would behave like. Can you elaborate a little bit? Or show some pictures that explain it?

[neut]

Thanks for the fast response. Essentially the feature is to group records by the contents of a grid column. Each column that is selected as "group by" divides all records into groups and displays them as sets of rows. In other words: the rows are divided into groups.

This can be done in a nested way. I doodled something to show what I mean, showing a "normal" grid and a grouped grid grouped by 1 column and grouped by 2 columns.

A reasonable implementation of this is done by sqlitemaestro. But I think it can be done better. I can make some suggestions when I have time tomorrow.

For reference I've added some more screenshots

[pawelsalawa]

Got it. Thanks.

[neut]

(For reference of this ticket)

The industry term for this feature is called pivot tables

[tuffnatty]

Another great implementation is Ultorg.