プロジェクト

全般

プロフィール

Vote #80733

完了

Sort does not work with group by datetime columns

Admin Redmine さんが3年以上前に追加. 3年以上前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Issues list_58
対象バージョン:
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
58
version_id:
160
issue_org_id:
33110
author_id:
29628
assigned_to_id:
1
comments:
9
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
127
ステータス-->[Closed]

説明

It is not possible to change sort order with introducted group by date columns (see #13803).

If you want to change sort order by clicking on column header, no changes are visible.


journals

Could you describe more details? I could not find any problem. Rows are sorted if you click the column header.
--------------------------------------------------------------------------------
Hi,

after testing it again, I found out, that this problem exists only in time entries list and project list. Issue list works as excepted.

E.g. for the bug:

# go to spent time list
# Group results by: Created (or any other of type TimestampQueryColumn)
# try to sort colmns (this does not work for any column)

ps: no plugins are installed for my tests. Redmine 4.1, Ruby 2.6.5, MySQL (also tested it with Postgres)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
I've investigated this issue and the sort works, but not as expected because the sort takes into consideration the time of timestamp columns and not only the date value as the grouping does. Also, the problem can be reproduced on issues list as well if you have the correct test data. More details in the patch.

I was to able to fix by using the attached patch. Jean-Philippe, please take a look on this. All tests pass on my CI: https://gitlab.com/redmine-org/redmine/pipelines/130760933

@Alexander, can you confirm the fix, please?

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Hi Marius,

thanks for the patch! This solved the problem. Create work and not easy to address the problem.
--------------------------------------------------------------------------------
Committed, thanks.
--------------------------------------------------------------------------------
Merged.
--------------------------------------------------------------------------------


related_issues

relates,Closed,13803,Implement grouping issues by date (start, due, creation, update, closing dates)

Admin Redmine さんが3年以上前に更新

  • カテゴリIssues list_58 にセット
  • 対象バージョン4.1.1_160 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0