Re: Find records with no values in solr.LatLongType fied type

[Erick Erickson <er...@gmail.com>]

BTW, there's a JIRA for this, it's a bit clumsy to have to
know about how the coordinate fields are split up

And I like Ishan's idea too!


On Wed, Sep 30, 2015 at 11:51 AM, Ishan Chattopadhyaya
<ic...@gmail.com> wrote:
> 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 <er...@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
>> > <kk...@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.
>> >
>>