Re: Reverse range query

[Erick Erickson]

Well, what does adding debug=query show you for the parsed query? What
documents show up?

My first guess is that since you're using exclusive rather than inclusive
end points you're expectations aren't what you think.

Best
Erick


On Mon, Feb 11, 2013 at 10:57 PM, ballusethuraman ballusethura...@gmail.com
 wrote:

 Hi,
 I have craeted new attribute(Year) in attribute dictionary and associated
 with different catentries with different values say
 2000,2001,2002,2003,...2012.
 Now I want to search with the Year attribute with min and max range. when
 2000 to 2005 is given as search condition it should fetch the catentries
 which is between these two values.
 This is the url I used to hit the solr server.
 ads_f11001 is the logical name of the attribute year that i have created
 in management center. This value will be in srchattrprop table. 2000 and
 2005 is min and max range.
 http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{2000
 2005}

 when i try to hit this url i am getting 0 records found.
 http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{2000
 TO *}

 and

 http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{*TO
 2005}

 These above two urls ferching me some result but it s not the expected
 result. Plz help me to solve this issue.



 --
 View this message in context:
 http://lucene.472066.n3.nabble.com/Reverse-range-query-tp1789135p4039860.html
 Sent from the Solr - User mailing list archive at Nabble.com.

Re: Reverse range query

[ballusethuraman]

Hi,
I have craeted new attribute(Year) in attribute dictionary and associated
with different catentries with different values say
2000,2001,2002,2003,...2012.
Now I want to search with the Year attribute with min and max range. when
2000 to 2005 is given as search condition it should fetch the catentries
which is between these two values. 
This is the url I used to hit the solr server.
ads_f11001 is the logical name of the attribute year that i have created
in management center. This value will be in srchattrprop table. 2000 and
2005 is min and max range.
http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{2000
2005}

when i try to hit this url i am getting 0 records found.
http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{2000
TO *}

and

http://localhost/solr/MC_10701_CatalogEntry_en_US/select?q=ads_f11001:{* TO
2005}

These above two urls ferching me some result but it s not the expected
result. Plz help me to solve this issue.



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Reverse-range-query-tp1789135p4039860.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Reverse range query

[brian519]

This post helped me solve my problem which I had posted on StackOverflow. 
See my answer here: 
http://stackoverflow.com/questions/8070742/solr-multivalued-field-how-can-i-return-documents-where-all-values-in-the-fiel
http://stackoverflow.com/questions/8070742/solr-multivalued-field-how-can-i-return-documents-where-all-values-in-the-fiel
 

Would be great to see a feature in Solr for a reverse query.  Ie, the
value in your solr document is queried against your query input, which
would make problems like this a breeze.

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Reverse-range-query-tp1789135p3497482.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Reverse range query

[kenf_nc]

I modified the text of this hopefully to make it clearer. I wasn't sure what
I was asking was coming across well. And I'm adding this comment in a
shameless attempt to boost my question back to the top for people to see.
Before I write a messy work around, just wanted to check the community to
see if this was already handled, it seems like a useful, common, data type.
-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/Reverse-range-query-tp1789135p1792126.html
Sent from the Solr - User mailing list archive at Nabble.com.