Defect #11426
closedFiltering with Due Date in less than N days should show overdue issues
0%
Description
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.
Related issues
Updated by Jean-Philippe Lang about 12 years ago
- Status changed from New to Confirmed
Updated by Jean-Philippe Lang almost 12 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
Updated by Egidijus Zideckas over 11 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.
Updated by Egidijus Zideckas over 11 years ago
At least I propose to change names of operators:
- "less than days 3 ago" => "later than 3 days ago"
- "in less than 3 days" => "earlier than in 3 days"
Cheers!