And you'll need to re-index once you make the schema change. On Fri, Mar 20, 2009 at 5:24 PM, Shalin Shekhar Mangar < shalinman...@gmail.com> wrote:
> 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. > -- Regards, Shalin Shekhar Mangar.
