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

Sort a->z rows

solovej posted 2 years ago in General
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 posted 2 years ago
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 posted 2 years ago
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 posted 2 years ago
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 posted 2 years ago
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.