What is the type of the productPrice_product_str field? I'm guessing that it is a string type.
Since it is a float value and you need range search, you should change this to a 'sfloat' or 'sdouble' in your schema.xml On Fri, Mar 20, 2009 at 5:11 PM, dabboo <ag...@sapient.com> wrote: > > I am using this query only but I am getting the same results. > > > > facet=true&facet.field=productPrice_product_str_s&fq=productPrice_product_str_s:[1%20TO%20100] > > > - <lst name="facet_fields"> > - <lst name="productPrice_product_str_s"> > <int name="100">202</int> > <int name="10">57</int> > <int name="10.6">14</int> > <int name="10.2">11</int> > <int name="10.67">10</int> > <int name="10.8">9</int> > <int name="10.99">9</int> > <int name="1.33">7</int> > <int name="1">6</int> > <int name="10.4">5</int> > <int name="10.34">4</int> > <int name="1.01">2</int> > <int name="1.2">2</int> > <int name="1.66">2</int> > <int name="10.63">2</int> > <int name="10.66">2</int> > <int name="1.4">1</int> > <int name="1.7">1</int> > <int name="1.8">1</int> > <int name="10.33">1</int> > <int name="10.75">1</int> > <int name="10.9">1</int> > <int name=".01">0</int> > <int name=".2">0</int> > <int name="0">0</int> > <int name="100.05">0</int> > <int name="100.07">0</int> > <int name="100.13">0</int> > <int name="100.2">0</int> > <int name="100.25">0</int> > <int name="100.33">0</int> > <int name="100.4">0</int> > <int name="100.45">0</int> > <int name="100.53">0</int> > <int name="100.6">0</int> > <int name="100.67">0</int> > <int name="100.73">0</int> > <int name="100.8">0</int> > <int name="100.87">0</int> > <int name="100.95">0</int> > <int name="100.96">0</int> > <int name="101">0</int> > <int name="101.1">0</int> > <int name="101.13">0</int> > <int name="101.2">0</int> > <int name="101.27">0</int> > <int name="101.33">0</int> > <int name="101.4">0</int> > <int name="101.47">0</int> > <int name="101.6">0</int> > <int name="101.67">0</int> > <int name="101.73">0</int> > <int name="101.8">0</int> > <int name="101.87">0</int> > > It still is not showing up the other values. Do I need to make any entry in > schema or solrConfig xml files. Do I need to convert the string into > numeric > values etc etc. > > Please suggest. > > Thanks, > Amit > > > Shalin Shekhar Mangar wrote: > > > > On Fri, Mar 20, 2009 at 4:00 PM, dabboo <ag...@sapient.com> wrote: > > > >> > >> Hi Shalin, > >> > >> One more thing, > >> > >> > >> > facet.field=productPrice_product_str_s&facet.query=productPrice_product_str_s:[0%20TO%20100] > >> > >> This is my query and these are results, I am getting: > >> > >> <int name="100">202</int> > >> <int name="10">57</int> > >> <int name="10.6">14</int> > >> <int name="10.2">11</int> > >> <int name="10.67">10</int> > >> <int name="10.8">9</int> > >> <int name="10.99">9</int> > >> <int name="1.33">7</int> > >> <int name="1">6</int> > >> <int name="10.4">5</int> > >> <int name="10.34">4</int> > >> <int name="1.01">2</int> > >> <int name="1.2">2</int> > >> <int name="1.66">2</int> > >> <int name="10.63">2</int> > >> <int name="10.66">2</int> > >> <int name="1.4">1</int> > >> <int name="1.7">1</int> > >> <int name="1.8">1</int> > >> <int name="10.33">1</int> > >> <int name="10.75">1</int> > >> <int name="10.9">1</int> > >> <int name=".01">0</int> > >> <int name=".2">0</int> > >> <int name="100.05">0</int> > >> <int name="100.07">0</int> > >> <int name="100.13">0</int> > >> <int name="100.2">0</int> > >> <int name="100.25">0</int> > >> <int name="100.33">0</int> > >> <int name="100.4">0</int> > >> <int name="100.45">0</int> > >> <int name="100.53">0</int> > >> <int name="100.6">0</int> > >> <int name="100.67">0</int> > >> <int name="100.73">0</int> > >> <int name="100.8">0</int> > >> <int name="100.87">0</int> > >> <int name="100.95">0</int> > >> <int name="100.96">0</int> > >> <int name="101">0</int> > >> <int name="101.1">0</int> > >> <int name="101.13">0</int> > >> <int name="101.2">0</int> > >> <int name="101.27">0</int> > >> <int name="101.33">0</int> > >> <int name="101.4">0</int> > >> <int name="101.47">0</int> > >> <int name="101.6">0</int> > >> <int name="101.67">0</int> > >> <int name="101.73">0</int> > >> <int name="101.8">0</int> > >> <int name="101.87">0</int> > >> <int name="102">0</int> > >> <int name="102.07">0</int> > >> <int name="102.19">0</int> > >> <int name="102.2">0</int> > >> <int name="102.27">0</int> > >> <int name="102.33">0</int> > >> <int name="102.4">0</int> > >> <int name="102.53">0</int> > >> <int name="102.6">0</int> > >> <int name="102.67">0</int> > >> <int name="102.8">0</int> > >> <int name="102.87">0</int> > >> <int name="102.93">0</int> > >> <int name="1022.4">0</int> > >> <int name="103">0</int> > >> > >> It is only returning results, which are having values started with 2, 3, > >> 4 > >> or some other integer instead of only 1. It is not returning records in > >> which value is >10 and <100. > >> > > > > Please do not send a duplicate mails. It will not help you get an answer > > faster. > > > > If you need to filter results to a specific range then you should use > > filter > > queries through the fq parameter: > > > > fq=productPrice_product_str_s:[0%20TO%20100] > > > > -- > > Regards, > > Shalin Shekhar Mangar. > > > > > > -- > View this message in context: > http://www.nabble.com/Issue-with-Facet-Query-tp22615577p22618714.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- Regards, Shalin Shekhar Mangar.
