Project

General

Profile

Actions

Feature #13803

closed

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

Added by # And almost 11 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Category:
Issues filter
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
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

Files


Related issues

Related to Redmine - Defect #30288: Groups are incorrect when grouping by date without user timezone setClosedJean-Philippe Lang

Actions
Related to Redmine - Feature #30233: Allow grouping of time entries by creation date ClosedGo MAEDA

Actions
Related to Redmine - Defect #32046: SQL to get counts when using created_on in MySQL to group issues does not work correctlyClosedGo MAEDA

Actions
Related to Redmine - Defect #33110: Sort does not work with group by datetime columnsClosedJean-Philippe Lang

Actions
Related to Redmine - Defect #33290: Unnecessary database access when IssueQuery class is definedClosedGo MAEDA

Actions
Has duplicate Redmine - Feature #20927: Group_by due_date on issue filterClosed

Actions
Has duplicate Redmine - Feature #23493: Add group results by due dateClosed

Actions
Has duplicate Redmine - Feature #13160: Group results by "Created"Closed

Actions
Actions #1

Updated by Filou Centrinov almost 11 years ago

Related: #13160

Actions #2

Updated by Go MAEDA over 8 years ago

  • Has duplicate Feature #20927: Group_by due_date on issue filter added
Actions #3

Updated by Sebastian Paluch about 8 years ago

+1

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

Actions #4

Updated by Sebastian Paluch about 8 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.

Actions #5

Updated by Go MAEDA over 7 years ago

Actions #6

Updated by Go MAEDA almost 6 years ago

  • Category changed from Issues to Issues filter
Actions #7

Updated by Senya Senya over 5 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

Actions #8

Updated by Jean-Philippe Lang over 5 years ago

  • Assignee set to Jean-Philippe Lang
  • Target version set to 4.1.0
Actions #9

Updated by Marius BĂLTEANU over 5 years ago

Actions #10

Updated by Marius BĂLTEANU over 5 years ago

Actions #11

Updated by Marius BĂLTEANU over 5 years ago

Nice addition.

Regarding MySQL, do you have any concern?

Actions #12

Updated by Jean-Philippe Lang over 5 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.

Actions #13

Updated by Marius BĂLTEANU over 5 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

Actions #15

Updated by Jean-Philippe Lang over 5 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.

Actions #16

Updated by Go MAEDA about 5 years ago

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

Updated by Go MAEDA about 5 years ago

  • Status changed from Closed to Reopened

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

Actions #18

Updated by Go MAEDA about 5 years ago

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

Updated by Go MAEDA almost 5 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.

Actions #20

Updated by Go MAEDA over 4 years ago

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

Updated by Marius BĂLTEANU almost 4 years ago

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

Updated by Go MAEDA almost 4 years ago

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

Also available in: Atom PDF