Defect #1841: Include both first and last name when sorting by users - Redmine

Defect #1841

Include both first and last name when sorting by users

Added by Artem Vasiliev almost 14 years ago. Updated over 13 years ago.

Status:

Closed

Start date:

2008-09-02

Priority:

Normal

Due date:

Assignee:

% Done:

Category:

Issues

Target version:

0.9.0

Resolution:

Fixed

Affected version:

Description

First, user dropdown sorting (e.g. 'Assigned to' field in Edit Issue screen) is far from obvious. I found explanation in #507 just occasionally. Let's sort by (first name, last name) pair. This will improve user dropdown usability because it will be consistent with the way user name is displayed (and choosing user dropdown items by keyboard will start to work).

Next, sorting by just last name doesn't scale: even our small company now has two people with the same last name and issues list sorting by Assigned To looks just broken for them (see attachment).

bad_issues_sorting_by_assigned.png (81.7 KB) Artem Vasiliev, 2008-09-02 10:17

Related issues

Associated revisions

Revision 2351
Added by Jean-Philippe Lang over 13 years ago

Include both last and first name when sorting issues by assignee (#1841).

History

#1 Updated by Eric Davis almost 14 years ago

My patch on issue #1708 allows user sorting to be customized by the admin. It includes options to sort by first name, last name, or login name.

#2 Updated by Artem Vasiliev almost 14 years ago

Eric Davis wrote:

My patch on issue #1708 allows user sorting to be customized by the admin. It includes options to sort by first name, last name, or login name.

That's great, thanks!

#3 Updated by Artem Vasiliev almost 14 years ago

Artem Vasiliev wrote:

Eric Davis wrote:

My patch on issue #1708 allows user sorting to be customized by the admin. It includes options to sort by first name, last name, or login name.

That's great, thanks!

Uhh, that's not what we want actually. We need it to be sorted by pair - like

ORDER BY firstname, lastname

#4 Updated by Artem Vasiliev almost 14 years ago

Patch is committed to http://github.com/artemv/redmine_tt/commit/3246d2bd8fed74c4ea0ac29e9c7dff74897395ac.
The part for issue list sorting is a hardcore hack however - making it right needs some multifield sorting support from Redmine first.