distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sort a->z rows

User, date Message
Written by solovejMoney, Euro
2 years ago
Category: General
6 posts since Wed, 12 Oct 11
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.



Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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?
Written by jfalchMoney, Euro
2 years ago
380 posts since Sat, 17 Oct 09
workaround (for information only):
SELECT * FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA='your_database' AND TABLE_NAME='your table'
ORDER BY COLUMN_NAME ASC
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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?
Written by kalvaro
2 years ago
587 posts since Thu, 29 Nov 07
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.