Bug #18811
closed
Searching for future dates by day is not relative to today
Added by Thomas McKay over 7 years ago.
Updated about 6 years ago.
Description
Today is: 2017-03-06 (day 65)
Database record is: 2017-06-19 (day 170)
Search success: expires < "172 days"
Search zero results: expires < "171 days"
Search zero results: expires < "Today + 175 days"
As a user, my expectation is that date searches are relative to today. Trying "Today +" syntax also yields zero results.
https://github.com/wvanbergen/scoped_search/issues/162
- Bugzilla link set to 1429629
can you provide more examples on how you want to use it? I wonder if there are easy workarounds to your issue.
The use case is to search for subscriptions expiring in less than 30 days, as an example.
Time is normally thought of as relative to now. So when I say, "Expiring in less than 30 days" that implies a search for objects with an expiration falling within the window of now to now+30days. When I say, "Expired within the last 30 days" that implies an expiration falling within now to now-30days.
- Project changed from Foreman to Katello
- Category deleted (
Search)
- Status changed from New to Assigned
- Assignee set to Thomas McKay
- Translation missing: en.field_release set to 211
- Status changed from Assigned to Resolved
- Translation missing: en.field_release changed from 211 to 166
This should be resolved by new scoped search
Also available in: Atom
PDF