Feature #13803
Implement grouping issues by date (start, due, creation, update, closing dates)
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due 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 
(2.02 KB)
0001-Implemented-for-MySQL-as-well.patch
(846 Bytes)
0001-Implemented-for-MySQL-as-well_v2.patch
(954 Bytes)
Related issues
Associated revisions
Allow issues grouping by start and due dates (#13803).
Allow issues grouping by creation, update and closing date (#13803).
Implemented for PostgreSQL only for now.
Implement date grouping for MySQL (#13803).
Patch by Marius BALTEANU.
History
#1
Updated by Filou Centrinov almost 7 years ago
Related: #13160
#2
Updated by Go MAEDA over 4 years ago
- Duplicated by Feature #20927: Group_by due_date on issue filter added
#3
Updated by Sebastian Paluch about 4 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 about 4 years ago
- File issue_query.rb.patch added
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 over 3 years ago
- Duplicated by Feature #23493: Add group results by due date added
#6
Updated by Go MAEDA almost 2 years ago
- Category changed from Issues to Issues filter
#7
Updated by Senya Senya over 1 year 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 1 year ago
- Assignee set to Jean-Philippe Lang
- Target version set to 4.1.0
#9
Updated by Marius BALTEANU over 1 year ago
- Related to deleted (Feature #13160: Group results by "Created")
#10
Updated by Marius BALTEANU over 1 year ago
- Duplicated by Feature #13160: Group results by "Created" added
#11
Updated by Marius BALTEANU over 1 year ago
Nice addition.
Regarding MySQL, do you have any concern?
#12
Updated by Jean-Philippe Lang over 1 year 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 1 year ago
- File 0001-Implemented-for-MySQL-as-well.patch added
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 1 year ago
- File 0001-Implemented-for-MySQL-as-well_v2.patch added
Made a small improvement.
#15
Updated by Jean-Philippe Lang over 1 year 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 1 year ago
- Related to Defect #30288: Groups are incorrect when grouping by date without user timezone set added
#17
Updated by Go MAEDA over 1 year ago
- Status changed from Closed to Reopened
An issue regarding this feature has been reported as #30288.
#18
Updated by Go MAEDA about 1 year ago
- Related to Feature #30233: Allow grouping of time entries by creation date added
#20
Updated by Go MAEDA 7 months 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 7 days ago
- Related to Defect #33110: Sort does not work with group by datetime columns added