#18 Provide "ORDER BY" field in the Content view

[Anonymous]

Under the "Content" tab, it would be nice to have an "ORDER BY"
field. Sometimes I need to sort results by more than one field at a
time, to make editing more efficient -- in which case, clicking the
column headers is not sufficient as a means of sorting.

I realize sorting can be done under the "Custom Query" tab, but
editing of rows is not possible under Custom Query, so that option is
inconvenient.

[Nobody/Anonymous]

Logged In: NO

Perhaps the UI should remember the sequence in which you changed the sort order,
so that after first sorting by, say, first name, and then by surname, those entities
with the same surname would remain sorted by first name.

Filemaker has a 'sort widget' which works very nicely, but is not a good fit for
sorting a 'content view' of a table. You are right that a custom query is the correct
way to handle this (and would also allow HAVING).

You might be better asking for the rows returned by a custom query to be editable.
If you have a primary key, is there a technical reason why they should not be?