Try looking at range JSON facets:
https://lucene.apache.org/solr/guide/8_2/json-facet-api.html#range-facet.
If you facet over the eventTimeStamp with a gap of 1 day, you should
then be able to use a sub facet to return a min and max value
(https://lucene.apache.org/solr/guide/8_2/json-facet-api
I hope you do not plan to use Solr as a primary repository. Solr is NOT a
database. If you use Solr as a database, you will lose data at some point.
The Solr feature set is very different from MySQL. There is no guarantee that a
SQL query can be translated into a Solr query.
wunder
Walter Under
