Defect #6244

Sort people by display name

Added by Ewan Makepeace over 9 years ago. Updated about 7 years ago.

Status:NewStart date:2010-08-29
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution: Affected version:


I have set my user display to be <FirstName> <LastName>

In drop down lists users are sorted in that order:

However on display of issues, both sorting on Assigned To column, and grouping on Assigned To still sorts by LastName, FirstName which is surprisingly hard to work with - I can never find the people I am looking for:

Related #1841, #1708

dropdown.jpg (43.7 KB) Ewan Makepeace, 2010-08-29 08:01

sorted.jpg (49.1 KB) Ewan Makepeace, 2010-08-29 08:01

grouped.jpg (35.3 KB) Ewan Makepeace, 2010-08-29 08:01

0001-Fix-6244-Make-Issues-use-Setting.user_format.patch Magnifier - Patch for defect 6244 -- respect Setting.user_format in Issues display (4.4 KB) Steven Chanin, 2010-09-21 21:21


#1 Updated by Steven Chanin over 9 years ago

The problem was that the query#available_columns was using a hard coded set of mappings for @@available_columns to convert between logical columns and underlying database columns to sort by and was not taking into account the value for user_format in the Settings table.

The following small patch (with tests) changes this. All specs pass and I have manually tested things in a browser in both development and production modes.

I haven't looked at the Redmine code in a couple of years, so please review the patch before applying.

#2 Updated by Eric Davis over 9 years ago

  • Category changed from UI to Issues
  • Status changed from Resolved to New
  • Assignee deleted (Eric Davis)

Please don't mark an issue as resolved or assign it to anyone.

#3 Updated by Eric Davis over 9 years ago


Can you take a look at this bug (and patch) and let me know what you think? 1.0.x or 1.1?

#4 Updated by Felix Schäfer over 9 years ago

  • Status changed from New to 7
  • Assignee set to Felix Schäfer

Will do, probably this WE.

#5 Updated by Felix Schäfer about 9 years ago

  • Assignee deleted (Felix Schäfer)

#6 Updated by Jean-Philippe Lang about 7 years ago

  • Status changed from 7 to New

Assigned issue with no assignee back to New status.

Also available in: Atom PDF