MySQL Bugs: #55984: Toggle descending sort for Output grid

Bug #55984	Toggle descending sort for Output grid
Submitted:	15 Aug 2010 0:44	Modified:	24 Aug 2010 14:23
Reporter:	Dan Kloke (Candidate Quality Contributor)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.26 CE	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	DESC, descending, grid, Output, qc, sort

Description:
Love the output grid. Wrap toggle is a great feature.

Would like to be able to sort the grid in descending order by datetime (Time col), colun #2 (unlabeled), or Message.. or any column really.

May need some tweaking to work with auto-scroll so that the currently executing query's row shows while that query is running.

Just add click column header to sort and it's done, maybe add sort icons as in the Results tabs.

How to repeat:
View Output window. Desire to sort in descending order by some column.

Suggested fix:
The UI magic of clickable headers.

I am not sure I get this request properly. On mac OS X, for example, with 5.2.26, I can click on any column header in the results tab and change sorting order for it: ascending, descending or no sorting. Proper icon with arrow up or arrow down shows current sorting order order. What else do you need?

This is in reference to the grid of messages in the Output/Actions tab, not the result set grid in Result tabs.

In Windows at least, the Output/Actions grid auto scrolls down to the most recent entry, but does not do so well, especially when the "Toggle wrapping of entries" is enabled. 

My request is that this grid of output messages be made sortable, at least descending by Time. This is arguably a matter of taste to some degree, but it might be easily implemented. Making all columns sortable in potentially use3ful ways might become more complicated. Column filtering might also be useful here, to assist searching for particular types of messages.

Now I've got your point.

I am quite surprised this has not been addressed already. Do others really prefer the LATEST action to be at the BOTTOM of the output grid? This makes it incredibly difficult to track errors and such. 

No other product works this way. The latest events are always at the top and work their way backwards. IF there were 4000 actions in that window it means it would have to scroll all the way down instead of inserting at the top which involves 0 scrolling. 

Such a shame for a nice looking product.

This is the only thing that annoys me about the product. I'm constantly getting confused by the latest message being sent to the end of the output list instead of the top. I'm sure this must be a simple coding tweak to make the window sortable.