Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
From: Gethin James <gethin.james@alfresco.com>
To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
Subject: Re: Regarding /sql -- WHERE <<field_name>> IS NULL and IS NOT NULL
Thread-Topic: Regarding /sql -- WHERE <<field_name>> IS NULL and IS NOT NULL
Thread-Index: AQHSZ4awYgiTDsxRU0+XftAYOQfquKEqQDeAgAWtXkE=
Date: Mon, 9 Jan 2017 09:56:00 +0000
Message-ID: <DM5PR03MB2795A1BA9C9E919BB5C14B8AF1640@DM5PR03MB2795.namprd03.prod.outlook.com>
References: <CAPUMpAwcdVfjxJxganCyRUodRNk8Xzioe6aK9j04B7QmOGj4hA@mail.gmail.com>,<CAE4tqLNx+rE0LOMYCrpyP7GpBLonTFrjD3hQSuGB2ifcsd8amQ@mail.gmail.com>
In-Reply-To: <CAE4tqLNx+rE0LOMYCrpyP7GpBLonTFrjD3hQSuGB2ifcsd8amQ@mail.gmail.com>
Accept-Language: en-GB, en-US
Content-Language: en-GB
received-spf: None (protection.outlook.com: alfresco.com does not designate
 permitted sender hosts)
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_DM5PR03MB2795A1BA9C9E919BB5C14B8AF1640DM5PR03MB2795namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Jan 2017 09:56:00.7447
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a92a627e-e9ce-48ba-8edb-6c64a4dbcf34
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR03MB2794
archived-at: Mon, 09 Jan 2017 09:56:14 -0000

--_000_DM5PR03MB2795A1BA9C9E919BB5C14B8AF1640DM5PR03MB2795namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 handle=
r
> ?
>
> " 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
>

--_000_DM5PR03MB2795A1BA9C9E919BB5C14B8AF1640DM5PR03MB2795namp_--