For NOT NULL, I had some success using:
WHERE field_name <> '' (greater or less than empty quotes) Best regards, Gethin. ________________________________ From: Joel Bernstein <joels...@gmail.com> Sent: 05 January 2017 20:12:19 To: solr-user@lucene.apache.org Subject: Re: Regarding /sql -- WHERE <<field_name>> IS NULL and IS NOT NULL IS NULL and IS NOT NULL predicate are not currently supported. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Jan 5, 2017 at 2:05 PM, radha krishnan <dradhakrishna...@gmail.com> wrote: > Hi, > > solr version : 6.3 > > will WHERE <<field_name>> IS NULL / IS NOT NULL work with the /sql handler > ? > > " select name from gettingstarted where name is not null " > > the above query is not returning any documents in the response even if > there are documents with "name"defined > > > Thanks, > Radhakrishnan D >