#4317 (ok 4.2) No visual cue when a table is sorted by multiple columns

[Aditya Sastry]

Not really sure if this could be called a feature request.

When I sort a table by a column by clicking on it, I see a arrow on it that tells me that the table is sorted by that column and the direction of the arrow tells me if it is ordered in a ascending or a descending order.

But when I do the same for multiple columns using the query such as
select * from table_name order by column1 asc, column2 desc. There are no arrows on any columns !

[Marc Delisle]

What do you propose as a visual cue? For example, if we put arrows with the appropriate direction on each column, what would happen if the user clicks on just one arrow?

[Aditya Sastry]

If the column1 is sorted in desc, clicking on the arrow which by the way should be displayed in the same way as the arrow that is displayed when sorted by a single column, should sort the table with that column in asc order.

Like if the query is

select * from table_name order by abc asc, bcd desc

clicking on the arrow of bcd desc should turn the query into

select * from table_name order by abc asc, bcd asc

[Marc Delisle]

This would not be consistent with the current behavior of sorting on just one column when you click on this column's arrow.

[Aditya Sastry]

sorry that was a typo, I typed bcd desc twice in both the queries.

[Aditya Sastry]

This is required for the feature request 1507
http://sourceforge.net/p/phpmyadmin/feature-requests/1507/

[Marc Delisle]

There are visual cues in 4.2.0-beta1.