Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAK7c9g3iYA-p2PzNAhFP3JnWf32HzgW-c89NQPiG=9A_b7VWng@mail.gmail.com>
References: 
 <CAK7c9g3nhVT2EcVpv48gwbXsgG-7DU88s3wTe9QrZAXKStHc1Q@mail.gmail.com>
	<CAN4YXve_6QDw3vL7Z-fcnPBnxZ=UNR1Cs0ti=YGXxjm=gUHbFA@mail.gmail.com>
	<CAK7c9g3iYA-p2PzNAhFP3JnWf32HzgW-c89NQPiG=9A_b7VWng@mail.gmail.com>
Date: Thu, 1 Oct 2015 00:21:19 +0530
Message-ID: 
 <CAHPRk5G0LVPAx-Kb-1P4jPHcKgmZM-m0FyF9r5_NDxeG_aC_wQ@mail.gmail.com>
Subject: Re: Find records with no values in solr.LatLongType fied type
From: Ishan Chattopadhyaya <ichattopadhyaya@gmail.com>
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a11409d468adce80520fb6af8

--001a11409d468adce80520fb6af8
Content-Type: text/plain; charset=UTF-8

There's also a function, exists(), which might work here, and result in a
neater query.
e.g. something like: q=*:* -exists(usrlatlong_0_coordinate)
Haven't tried it, though.
https://cwiki.apache.org/confluence/display/solr/Function+Queries#FunctionQueries-AvailableFunctions

On Wed, Sep 30, 2015 at 8:17 PM, Kamal Kishore Aggarwal <
kkroyal.192@gmail.com> wrote:

> Thanks Erick..it worked..
>
> On Wed, Sep 16, 2015 at 9:21 PM, Erick Erickson <erickerickson@gmail.com>
> wrote:
>
> > Top level queries need a *:* in front, something like
> > q=*:* -usrlatlong_0_coordinate:[* TO *]
> >
> > I just took a quick check and just using usrlatlong:[* TO *]
> > encounters a parse error.
> >
> > P.S. It would help if you told us what you _did_ receive
> > when you tried your options. Parse errors? All docs?
> >
> > Best,
> > Erick
> >
> > On Mon, Sep 14, 2015 at 10:58 PM, Kamal Kishore Aggarwal
> > <kkroyal.192@gmail.com> wrote:
> > > Hi,
> > >
> > > I am working on solr 4.8,1. I am trying to find the docs where
> > latlongtype
> > > have null values.
> > >
> > > I have tried using these, but not getting the results :
> > >
> > > 1) http://localhost:8984/solr/IM-Search/select?q.alt=-usrlatlong:[' '
> > TO *]
> > >
> > > 2) http://localhost:8984/solr/IM-Search/select?q.alt=-usrlatlong:[* TO
> > *]
> > >
> > > Here's the configurations :
> > >> <fieldType name="latlongtype" class="solr.LatLonType"
> > >> subFieldSuffix="_coordinate"/>
> > >> <field name="usrlatlong" type="latlongtype" indexed="true"
> stored="true"
> > >> required="false" multiValued="false" />
> > >
> > >
> > > Please help.
> >
>

--001a11409d468adce80520fb6af8--