I have a view of items that have a due date, and I want to be able to expose a boolean filter "Is overdue by more than 30 days"
I can create a filter on this due date as a relative date filter "<= today -30 days"; however this filter is always active on the view.
The best I've been able to come up with is to add a new boolean field on my content type "date_filter" that is always null, and in the view create a new exposed filter "is not null" (i.e, when active, will always be false).
Then add this filter to a new OR filter group with the above relative date filter. This works, as when the filter is "off" it returns true and overrides the relative date filter. When on, only the rows that fit the date filter are returned.
However, is there a way to do this without adding dummy fields? Ideally a module I can use to do this. I'd prefer not to have to write a hook just for this filter.