Feature #13803

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

Added by # And over 6 years ago. Updated 3 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Issues filter
Target version:4.1.0
Resolution:Fixed

Description

  • 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

issue_query.rb.patch Magnifier (2.02 KB) Sebastian Paluch, 2016-01-27 11:42

0001-Implemented-for-MySQL-as-well.patch Magnifier (846 Bytes) Marius BALTEANU, 2018-12-14 22:39

0001-Implemented-for-MySQL-as-well_v2.patch Magnifier (954 Bytes) Marius BALTEANU, 2018-12-15 16:29


Related issues

Related to Redmine - Defect #30288: Groups are incorrect when grouping by date without user t... Closed
Related to Redmine - Patch #30233: Implement grouping time entries by creation date Closed
Related to Redmine - Defect #32046: SQL to get counts when using created_on in MySQL to group... Closed
Duplicated by Redmine - Feature #20927: Group_by due_date on issue filter Closed
Duplicated by Redmine - Feature #23493: Add group results by due date Closed
Duplicated by Redmine - Feature #13160: Group results by "Created" Closed

Associated revisions

Revision 17723
Added by Jean-Philippe Lang 9 months ago

Allow issues grouping by start and due dates (#13803).

Revision 17724
Added by Jean-Philippe Lang 9 months ago

Allow issues grouping by creation, update and closing date (#13803).

Implemented for PostgreSQL only for now.

Revision 17745
Added by Jean-Philippe Lang 9 months ago

Implement date grouping for MySQL (#13803).

Patch by Marius BALTEANU.

Revision 18460
Added by Go MAEDA 6 days ago

Fix that date grouping for MySQL is not working (#32046, #13803).

Patch by Mizuki ISHIKAWA.

History

#1 Updated by Filou Centrinov over 6 years ago

Related: #13160

#2 Updated by Go MAEDA almost 4 years ago

  • Duplicated by Feature #20927: Group_by due_date on issue filter added

#3 Updated by Sebastian Paluch over 3 years ago

+1

But I'm not sure if grouping should be by date day or maybe by date week or month...

#4 Updated by Sebastian Paluch over 3 years ago

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.

#5 Updated by Go MAEDA about 3 years ago

#6 Updated by Go MAEDA over 1 year ago

  • Category changed from Issues to Issues filter

#7 Updated by Senya Senya 11 months ago

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

#8 Updated by Jean-Philippe Lang 9 months ago

  • Assignee set to Jean-Philippe Lang
  • Target version set to 4.1.0

#9 Updated by Marius BALTEANU 9 months ago

#10 Updated by Marius BALTEANU 9 months ago

#11 Updated by Marius BALTEANU 9 months ago

Nice addition.

Regarding MySQL, do you have any concern?

#12 Updated by Jean-Philippe Lang 9 months ago

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.

#13 Updated by Marius BALTEANU 9 months ago

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

#14 Updated by Marius BALTEANU 9 months ago

Made a small improvement.

#15 Updated by Jean-Philippe Lang 9 months ago

  • Subject changed from Implement grouping by date to Implement grouping issues by date (start, due, creation, update, closing dates)
  • Status changed from New to Closed
  • Resolution set to Fixed

Committed, thanks.

#16 Updated by Go MAEDA 9 months ago

  • Related to Defect #30288: Groups are incorrect when grouping by date without user timezone set added

#17 Updated by Go MAEDA 9 months ago

  • Status changed from Closed to Reopened

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

#18 Updated by Go MAEDA 6 months ago

  • Related to Patch #30233: Implement grouping time entries by creation date added

#19 Updated by Go MAEDA 3 months ago

  • Status changed from Reopened to Closed

Go MAEDA wrote:

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

It was fixed in r17745.

#20 Updated by Go MAEDA 8 days ago

  • Related to Defect #32046: SQL to get counts when using created_on in MySQL to group issues does not work correctly added

Also available in: Atom PDF