Vote #73793: Implement grouping issues by date (start, due, creation, update, closing dates) - redmineorg-copy202205 - Redmine

編集操作

リンクをコピー

Vote #73793

完了

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

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

ステータス:

Closed

優先度:

通常

担当者:

カテゴリ:

Issues filter_56

対象バージョン:

4.1.0_127

開始日:

2022/05/09

期日:

進捗率:

予定工数:

Redmineorg_URL:

https://www.redmine.org/issues/13803

category_id:

version_id:

127

issue_org_id:

13803

author_id:

57516

assigned_to_id:

comments:

status_id:

tracker_id:

plus1:

affected_version:

closed_on:

affected_version_id:

ステータス-->[Closed]

引用

説明

group by date creation asc
group by date creation desc
group by date start asc
group by date start desc
group by date end asc
group by date end desc
group by date closing asc
group by date closing desc

journals

Related: #13160
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1

But I'm not sure if grouping should be by date day or maybe by date week or month...
--------------------------------------------------------------------------------
Here is small patch that simply enables grouping for Start date, Due date, Created and Closed columns.

It would be very nice if this small change could be included in next release.
--------------------------------------------------------------------------------

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

--------------------------------------------------------------------------------
Basing on the patch, I've created a plugin for Redmine that allows grouping by date: https://gitlab.com/cmrd-senya/redmine_issues_date_grouping https://www.redmine.org/plugins/issue_date_grouping
--------------------------------------------------------------------------------

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

--------------------------------------------------------------------------------
Nice addition.

Regarding MySQL, do you have any concern?

--------------------------------------------------------------------------------
Marius BALTEANU wrote:
> Nice addition.
>
> Regarding MySQL, do you have any concern?

No, I just haven't had a look at it. Feel free to submit a patch.
--------------------------------------------------------------------------------
I think the attached patch should do the trick for MySQL as well.

Tests pass without skipping the tests added for this feature: https://gitlab.com/marius-balteanu/redmine/-/jobs/134925443
--------------------------------------------------------------------------------
Made a small improvement.
--------------------------------------------------------------------------------
Committed, thanks.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
An issue regarding this feature has been reported as #30288.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Go MAEDA wrote:
> An issue regarding this feature has been reported as #30288.

It was fixed in r17745.
--------------------------------------------------------------------------------

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

related_issues

relates,Closed,30288,Groups are incorrect when grouping by date without user timezone set
relates,Closed,30233,Allow grouping of time entries by creation date
relates,Closed,32046,SQL to get counts when using created_on in MySQL to group issues does not work correctly
relates,Closed,33110,Sort does not work with group by datetime columns
relates,Closed,33290,Unnecessary database access when IssueQuery class is defined
duplicates,Closed,20927,Group_by due_date on issue filter
duplicates,Closed,23493,Add group results by due date
duplicates,Closed,13160,Group results by "Created"