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 the SQL handler. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Mar 24, 2017 at 10:09 AM, GW <thegeofo...@gmail.com> wrote: > 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 >
