Admin: support ordering results

[XilinJia]

After opening the DB browser, it shows 50 rows on each page of the DB with 1000's of rows. When I press on a column name, it sorts the rows based on the column. Unfortunately, it does not re-sort the entire DB, it only sorts the 50 rows of the current page.

[greenrobot-team]

Sorry for the late response. Yes, that is a current limitation. Also data browser does not support ordering results at all currently.

Keeping this open as a feature request to support ordering results.

[ajans]

I just stumbled on this as I just increased the page-size of my paging list and wondered where the first-shown entities from the app-ui are.

Turns out, they are on page 4 of the db browser... :crying_cat_face:

Please fix this.

[ajans]

I would suggest to add a sort-button similar to the filter-button, and everytime this is pressed, add a row for property-selection and direction-dropdown.

The sort-columns specified this way would then be injected into the query for building the page, just as the filter-entries are.

Then you could disable the column-header-clicking and support multicolumn-sort with this, which would be very handy for supporting paged data. You know, sort by page-number first, then by order-column and so on.

This would make it so much easier to debug data-paging.