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