Sort a->z rows

[expired user #5977]'s profile image [expired user #5977] posted 11 years ago in General Permalink
Will be very pleasure if you can add possibility to click by Column "Name" for sorting column names A->Z and Z->A. Like in Data.



ansgar's profile image ansgar posted 11 years ago Permalink
Would be easy to do so. But this is intentionally left away from that list, as its important for the user to see the right order, as it's on the server. In other words: How would you get back to the original order once you have clicked that column header?
jfalch's profile image jfalch posted 11 years ago Permalink
workaround (for information only):
SELECT * FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA='your_database' AND TABLE_NAME='your table'
ORDER BY COLUMN_NAME ASC
ansgar's profile image ansgar posted 11 years ago Permalink
I just see I had put this "#" column at the very left, which contains the numeric position of the columns. So, if you want the original order, you would just click that column again to have it. Well.. is that a good idea or will users be confused? I am nearly sure there are some users clicking accidentally on some column, or?
kalvaro's profile image kalvaro posted 11 years ago Permalink
Meanwhile, you can just go to "Edit-> Filter panel". Probably, you want to sort columns so you're able to find a specific one.

Please login to leave a reply, or register at first.