Feature #13803

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

Added by # And over 8 years ago. Updated about 2 years 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 - Feature #30233: Allow grouping of time entries by creation date Closed
Related to Redmine - Defect #32046: SQL to get counts when using created_on in MySQL to group... Closed
Related to Redmine - Defect #33110: Sort does not work with group by datetime columns Closed
Related to Redmine - Defect #33290: Unnecessary database access when IssueQuery class is defined 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 over 2 years ago

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

Revision 17724
Added by Jean-Philippe Lang over 2 years ago

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

Implemented for PostgreSQL only for now.

Revision 17745
Added by Jean-Philippe Lang over 2 years ago

Implement date grouping for MySQL (#13803).

Patch by Marius BALTEANU.

Revision 18460
Added by Go MAEDA almost 2 years ago

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

Patch by Mizuki ISHIKAWA.

History

#1 Updated by Filou Centrinov about 8 years ago

Related: #13160

#2 Updated by Go MAEDA almost 6 years ago

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

#3 Updated by Sebastian Paluch over 5 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 5 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 almost 5 years ago

#6 Updated by Go MAEDA about 3 years ago

  • Category changed from Issues to Issues filter

#7 Updated by Senya Senya almost 3 years 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 over 2 years ago

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

#9 Updated by Marius BALTEANU over 2 years ago

#10 Updated by Marius BALTEANU over 2 years ago

#11 Updated by Marius BALTEANU over 2 years ago

Nice addition.

Regarding MySQL, do you have any concern?

#12 Updated by Jean-Philippe Lang over 2 years 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 over 2 years 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 over 2 years ago

Made a small improvement.

#15 Updated by Jean-Philippe Lang over 2 years 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 over 2 years ago

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

#17 Updated by Go MAEDA over 2 years ago

  • Status changed from Closed to Reopened

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

#18 Updated by Go MAEDA over 2 years ago

  • Related to Feature #30233: Allow grouping of time entries by creation date added

#19 Updated by Go MAEDA about 2 years 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 almost 2 years ago

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

#21 Updated by Marius BALTEANU over 1 year ago

  • Related to Defect #33110: Sort does not work with group by datetime columns added

#22 Updated by Go MAEDA over 1 year ago

  • Related to Defect #33290: Unnecessary database access when IssueQuery class is defined added

Also available in: Atom PDF