Single column sort instead of multi-column sort in Data Grid
Hope to here from you.
I would like to make a feature request out of this thread.
As we mostly need to quick sort by only one column it would be nice, if we can e.g. achieve this by Ctrl+Mouseclick on the desired column. That means if multiple fields are in the sort dropdown, the sort dropdown should be reset and then sort by desired column.
A shortcut to reset the sort dropdown also would be nice.
Thank you and regards
There is a context menu item with a shortcut for reset grid sorting - see the right-click menu. Shortcut defaults to Alt+S.
There are many ways to reset the sorting in the grid, which is a good thing. But it happens to me - multiple times a week - that I am confused or pretty stressed out, that I can't find the record I was expecting to find, because of an unexpected primary sorting somewhere on a column off the right side of my screen. Just to illustrate that I agree with Aybee :-)
Thanks for the great product, which I use everyday with great confidence.
So, what is your suggestion? Would that Ctrl+Click solution do it here?
In Windows conventions, using CTRL plus Click would mean changing the current selection (add or substract a column from the current selection), not resetting and starting a new selection.
Maybe you could make it a program setting? Multisort vs. Single sort. Maybe that the Data grid settings deserve their own tab under Preferences?
What about a new checkbox for that thingy in preferences > "Editor configuration" ? (which was "Data" previously and renamed incorrectly)
Thank you ansgar for the hint with Alt+S. I read the complete help file and didn't find it. Aoso I did not excpect to find it at this place.
To me best solution would be to have an icon on the menu bar for to switch between single and multi sort quickly.
Nice suggestion, Aybee. Would be great if Heidi remembers the switch.
Would be great if Heidi remembers the switch.
Yes, of course, good idea.
to have an icon on the menu bar for to switch between single and multi sort quickly.
... really? There are lots of buttons already. I see myself explaining people where this new button is and how it looks like.
I think at first I will add the number of sorted columns in the label of the "Sorting" button with the drop down arrow. This will make it much clearer whether there is 0, 1 or multiple sortings.
For that new Single sorting mode: I would prefer a checkbox in the drop down dialog of that Sorting button. That's the place where HeidiSQL has all other sorting options too, and people will search there.
That will be ok to me.
BTW: Nice tool, thank you for this.
Please login to leave a reply, or register at first.