Improve date filters by allowing multi step combinations
We currently have a lot of date filters like is before today
and is after today
, but if a user wants to make the combination is before or on today
, then it's not possible. We can add all the filter combinations, but we should look combining the values dynamically. That would mean we would have the following date filters:
- is before
- is before or on
- is after
- is after or on
- is
- is not
then there would be an extra step with options like:
- today + if chosen, no extra input
- tomorrow if chosen, no extra input
- yesterday if chosen, no extra input
- one week ago if chosen, no extra input
- one week from now + if chosen, no extra input
- one month ago + if chosen, no extra input
- one month from now + if chosen, no extra input
- number of days ago + if chosen, extra number input
- number of days from now + if chosen, extra number input
- exact date + if chosen, extra date input
We must then check if these options make some of the existing filter redundant. There must also be a migration path to convert the existing filters to the new format, and we must have a fallback when filtering via the API.