Can't sort by multiple fields when sorting by parent
It seems that the issue sort order set when creating custom query does not work when "Parent task" is involved.
Take a look on attached query screen shoot. It is a query that sorts first by "Parent task" to show hierarchy and then by "Update" field. The marked issues 21047 and 21069 have the same parent as others but much older date and should be listed at the end.
Also the change introduced in #2871 does not seem to work.
Environment: Redmine version 3.0.1.stable Ruby version 2.0.0-p594 (2014-10-27) [i386-mingw32] Rails version 4.2.0 Environment production Database adapter Mysql2 SCM: Subversion 1.8.11 Git 1.9.5 Filesystem Redmine plugins: inside_avatar 1.0.2 parent_issue_filter 1.0.1 redmine_agile 1.3.8 redmine_spent_time_column 2.1.0 redmine_version_fixed_issues 1.0.0 sidebar_hide 0.0.7
#1 Updated by Jean-Philippe Lang about 5 years ago
- Subject changed from Issue sort by multiple fields is broken to Can't sort by multiple fields when sorting by parent
- Status changed from New to Confirmed
Indeed. As far as I know there's no easy fix for this due to how sorting by parent works. Children have different lft values so the second order sort is never used.