Project

General

Profile

Actions

Feature #33308

open

Implement grouping by date (e.g start, due, creation, update, closing dates) for year and month/year

Added by Alexander Meindl almost 4 years ago. Updated almost 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues list
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

Date fields in queries should be groupable with year/month only - without day.

Implementation could be the same way as with TimestampQueryColumn. We could use DateQueryColumn.

The result should be (example data):

- 23/5/2019
- 24/5/2019
- 23/3/2019

for month/year:

  • 5/2019
    • 23/5/2019
    • 24/5/2019
  • 3/2019
    • 23/3/2019
for year:
  • 2019
    • 23/5/2019
    • 24/5/2019
    • 23/3/2019

This would require, that three options for one date exist:

  • Due date
  • Due date (Month/Year)
  • Due date (Year)

and

  • Start date
  • Start date (Month/Year)
  • Start date (Year)

etc.

What do you think about this idea?

Actions #1

Updated by Alexander Meindl almost 4 years ago

I used a wrong subject (copy of #13803). Creation, update, and closing dates does not fit, because it is Datetime. But this would be another interesting feature, to use month/year and year grouping not only for Date but Datetime fields.

Actions

Also available in: Atom PDF