0010853: In View Issues list, several columns are sorted by Id instead of display value - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0010853	mantisbt	filters	public	2009-08-20 05:33	2018-05-15 14:59

Reporter	wkarl	Assigned To	cproensa
Priority	low	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.2.0rc1
Target Version	2.13.0	Fixed in Version	2.13.0

Summary	0010853: In View Issues list, several columns are sorted by Id instead of display value
Description	While sort by "issue id" does make sense because the issue id is published and a sort of universal key, the sort by "category_id" is senseless because the category_id is not published. I propose it should be changed to sort by "category" and I suspect this is what the developers intend to do.
Additional Information	The same problem also applies to the following columns Reporter (reporter_id) Assigned To (handler_id) Project (project_id)
Tags	No tags attached.

has duplicate	0013149	closed	atrol	Incorrect sorting of categories
has duplicate	0013170	closed	rombert	Categories in the filter are sorted incorrectly
has duplicate	0014259	closed	dregad	Viewing Issues : Sort by "Assigned To Descending"
has duplicate	0014266	closed	dregad	Column "Assigned To" does not sort by name
has duplicate	0015409	closed	atrol	Reporter field in view issues page does not sort alphabetically
has duplicate	0017219	closed	dregad	Sort by category in View Issues page is broken
has duplicate	0022589	closed	dregad	View Issue page Category column sorting order is unknown
has duplicate	0011259	closed	dregad	Category column doesn't sort alphabetically on View Issues
has duplicate	0023400	closed	dregad	Category ascending sort incorrectly
related to	0024435	closed	atrol	show_user_realname_threshold is not considered when sorting by reporter or handler

wkarl 2009-08-20 05:57 reporter ~0022776	Please change category to "filters".

dregad 2012-05-15 08:40 developer ~0031843	As mentioned by atrol on the mailing list [1] this problem affects not only categories, but several other fields including project as well as user-based fields (reporter, handler). I have a work-in-progress branch [2] where I attempt to fix that. However, there are some issues related to how MantisBT displays the user name depending on user preferences ($g_show_realname) and the contents of the mantis_user_table. [1] http://thread.gmane.org/gmane.comp.bug-tracking.mantis.devel/3427/focus=3443 [2] https://github.com/dregad/mantisbt/commits/fix-10853-sort-category

dregad 2012-06-18 09:42 developer ~0032116	I just pushed an improved version of the branch, which includes code for better sorting of username fields (reporter_id and handler_id). I performed successful unit tests on MySQL and PostgreSQL (but no performance stress test as I don't have a large DB to use for that purpose). Your feedback and testing would be appreciated. You can download the code on Github (branch has been rebased on top of latest release 1.2.11). https://github.com/dregad/mantisbt/zipball/fix-10853-sort-category

vboctor 2014-09-19 02:12 manager ~0041250	@dregard, are you planning a pull request for this for 1.3?

dregad 2014-09-19 07:00 developer ~0041253	Guess I should, eh ? Thanks for the heads up, kinda forgot about this issue actually...

atrol 2014-09-19 07:30 developer ~0041254 Last edited: 2014-09-19 07:32	@dregad, I hope you are aware of what I wrote at http://thread.gmane.org/gmane.comp.bug-tracking.mantis.devel/3427/focus=3443 "This means, that you would have to sort AFTER ALL possible processing. Not really an option, because you would have to fetch all data before beeing able to show the right rows." This will introduce memory issues. [Edit] Maybe nonsense what I wrote. I just remembered our discussion, I didn't have a look at your branch.

icoams 2017-03-27 05:06 reporter ~0056218	Hi, I found that in mantis 2.2.0, Category column seems to be sorted by category id. Would you make the Category column to sort alphabetically?

icoams 2017-05-07 21:48 reporter ~0056800	Hi, any update?

hloehnert 2017-08-03 07:32 reporter ~0057382	For me this is a very annoying behavior! Is there any suggestion to solve it by a plugin-mechanism? The issue doesn't have any target version yet - will it be solved sometime? I'm using mantisbt 2.5.1.

dregad 2017-08-03 10:48 developer ~0057384	I don't think this can be achieved by a plugin. The code (for Mantis 1.2) is still in pretty much the same shape as it was 5 years ago; I don't have time to work on this for the time being unfortunately. Feel free to have a look https://github.com/dregad/mantisbt/tree/fix-10853-sort-category

atrol 2017-08-09 17:12 developer ~0057417	PR https://github.com/mantisbt/mantisbt/pull/1144

helfy022 2017-10-04 10:38 reporter ~0057890	Hello, Could you please note the target version for formally incorporating the update into the official MantisBT installation? Thanks, Ryan.

MantisBT: master fc48f232 2017-10-23 01:51 cproensa Committer: dregad Details Diff	Sort columns by names related to ids Sort by the actual names instead of the numerical ids for: - Category - Project - Reporter - Handler For user names: - show_realname should olny be set at global or all_projects - sort_by_last_name is not supported at sql query runtime. Fixes: 0010853		Affected Issues 0010853
	mod - core/classes/BugFilterQuery.class.php		Diff File

View Issue Details

Relationships

Activities

Related Changesets