MySQL Bugs: #55813: Sorting in MySQL Admin tool does not work

Bug #55813	Sorting in MySQL Admin tool does not work
Submitted:	6 Aug 2010 21:33	Modified:	24 Nov 2010 17:28
Reporter:	JD Bottorf	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.26	OS:	MacOS
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	admin, sort, sorting

Description:
When listing all connections, none of the columns are sortable.  I would expect that clicking on the header column would change the order from ascending to descending, but this is not the case.  Clicking has no effect.

How to repeat:
Open MySQL Workbench, connect to a MySQL server via Server Administration, click 'Connections' tab to list all connections, click on any header column (id, User, Host, DB, Command, Time, State, Info) to see nothing happen.

Suggested fix:
Change the sort order of values based on which header column is chosen.  I'd like to be able to sort connections based on host/DB/etc.

Thank you for the feature request.

This is true of all header columns....nothing is sortable.  This seems like such an obvious problem to me and I'm very surprised that it has not yet been fixed.  I guess I'm just really surprised that it's a problem to begin with.

marked bug #54807 as a duplicate

marked bug #50103 as duplicate

Implemented in MacOSX, Linux and Windows impl. pending

Linux impl fixed.

Fixed in repository.

Sorting for other relevant places was also enabled. Some places where it would be unnecessary or cause confusion were left out.

fix confirmed in repository. Most lists in Administration section are now sortable

An entry has been added to the 5.2.31 changelog:

In the Administrator, most columns were not sortable. For example, in the Connections tab, it was not possible to sort connections based on clicking the columns id, User, Host, DB, Command, Time, State, Info.

The "Users" Column in the "Schema Privileges" Tab are still not sortable.