Re: Regarding /sql -- WHERE <> IS NULL and IS NOT NULL

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: Re

Re: Regarding /sql -- WHERE <> 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 wrote: > Hi, > > solr version : 6.3 > > will WHERE <> IS NULL / IS NOT NULL work with the /sql handler > ? > >

Regarding /sql -- WHERE <> IS NULL and IS NOT NULL

Hi, solr version : 6.3 will WHERE <> 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