Bug #18811
closed
Searching for future dates by day is not relative to today
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.
Updated by Ohad Levy about 7 years ago
can you provide more examples on how you want to use it? I wonder if there are easy workarounds to your issue.
Updated by Thomas McKay about 7 years ago
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.
Updated by Dominic Cleal about 7 years ago
- Project changed from Foreman to Katello
- Category deleted (
Search)
Updated by Tomer Brisker about 7 years ago
https://github.com/wvanbergen/scoped_search/pull/163 has been merged, will need to get a new version of scoped search released to get it out.
Updated by Eric Helms about 7 years ago
- Status changed from New to Assigned
- Assignee set to Thomas McKay
- translation missing: en.field_release set to 211
Updated by Justin Sherrill about 7 years ago
- Status changed from Assigned to Resolved
- translation missing: en.field_release changed from 211 to 166
This should be resolved by new scoped search