SearchKit HAVING clause does not support relative dates.
Overview
SearchKit WHERE clauses on a Date field provide a facility for comparing with a relative date, e.g. "< Before Now 12 Months". The HAVING clause does not, but I am suggesting that it should.
Example use-case
- SearchKit search to select Contacts who have not participated in an Event for the last 12 months. Also applies to Activities, Memberships, etc.
Current behaviour
Can construct a HAVING clause to compare e.g. a MAX Date field with a literal date, but not with a relative date as for a WHERE clause.
Proposed behaviour
Relative dates should be provided for HAVING as well as WHERE clauses. This is much more user friendly for a packaged search than having to edit the search definition in SearchKit each time.
Comments
Anything else you would like the reviewer to note.