lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gethin James <gethin.ja...@alfresco.com>
Subject Re: Regarding /sql -- WHERE <<field_name>> IS NULL and IS NOT NULL
Date Mon, 09 Jan 2017 09:56:00 GMT
For NOT NULL, I had some success using:


WHERE field_name <> '' (greater or less than empty quotes)


Best regards,

Gethin.

________________________________
From: Joel Bernstein <joelsolr@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 <dradhakrishnan24@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message