You can use the _query_ field to support any Solr query in the where clause:
select a, b from c where _query_='(any solr query)'
This is definitely supported in the 6.5 release which is the first release
with Apache Calcite as the SQL engine. But I believe it's also supported in
older versions of
Dear reader,
I've found that using the distinct clause gives me the list I want.
I also have a multivalued rpt_location in the collection that I'd like to
use in the filter.
Is this possible in any way shape of form?
Many thanks in advance,
Greg
