Filtering with Due Date in less than N days should show overdue issues
|Assignee:||Jean-Philippe Lang||% Done:|
I appreciate that this is similar to other requests about date ranges and so forth, but I believe it is a distinct issue.
We have an issues filter that shows items due in the next 14 days (we use it with the reminder emails plugin). The query includes a filter "Due Date" + "in less than" + "14 days".
Some items are overdue - that is, in my mind, they are due in -n days. As any negative integer is less than 14, my assumption was that they would be included - however they're not.
Is this expected behaviour? I appreciate that this may be a decision taken during development rather than a bug, but if so then I cannot see a way to include items that are overdue in the same query.
If this is expected behaviour, I suppose this could be merged with #3868 (it could be achieved with two filters combined with an OR operator), however I suspect that I'm not the only person who would think that -n < n in this respect.
Redmine 1.3.2, MySQL 5.5 backend.
Changes how relative date filters work and adds specific filters for filtering dates in past/next n days (#11426).
#2 Updated by Jean-Philippe Lang almost 7 years ago
- Subject changed from Due Date issues filter does not allow for negative values to Filtering with Due Date in less than N days should show overdue issues
- Status changed from Confirmed to Closed
- Assignee set to Jean-Philippe Lang
- Target version set to 2.2.0
- Resolution set to Fixed
- "in less than 3 days": [date] <= today + 3 days
- "in the next 3 days": today <= [date] <= today + 3 days
#3 Updated by Egidijus Zideckas almost 7 years ago
-1. Let me explain why.
To my mind list of available date operators is too big, hard to figure out for inexperience user. This change makes it even bigger longer :(I tried to figure out differences between two operators while making new labels translation, at first new filters seem just duplicates:
- "less than days 3 ago" : today - 3 <= [date]
- "in the past 3 days" : today - 3 <= [date] <= today
Only after checking source code found this thin difference.
I'd stick with less but clear to understand list operators which are covering 95% of cases.