Solr Sorting is not working properly on long Fields
Hi, I am having a column named 'Kilometers' and when I try to sort with that it is not working properly.The values in 'Kilometers' column are,Kilometers171119792365611Values in 'Kilometers' after soting are Kilometers979236561117111The Problem here is, when 97 is compared with 923 it is taking 97 as bigger number since 97 is greater than 923. Initially Kilometers column was having string as datatype and I thought the problem could be because of that and i changed the datatype of that column to 'long'. Even then i couldn't see any change in the results.But when I insert values which are having same number of digits say, 1, 2, 3,4,5Kilometers21452 when i try to sort now it is working perfectlyKilometers12345Datatypes that I have tries are, Can anyone helpme to get rid out of this problem... Thanks in Advance -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Sorting-is-not-working-properly-on-long-Fields-tp4050833.html Sent from the Solr - User mailing list archive at Nabble.com.
Solr sorting is not working properly on long Fields
Hi, I am having a column named 'Kilometers' and when I try to sort with that it is not working properly. The values in 'Kilometers' column are, Kilometers 17 111 97 923 65 611 Values in 'Kilometers' after soting are Kilometers 97 923 65 611 17 111 The Problem here is, when 97 is compared with 923 it is taking 97 as bigger number since 97 is greater than 923. Initially Kilometers column was having string as datatype and I thought the problem could be because of that and i changed the datatype of that column to 'long'. Even then i couldn't see any change in the results. But when I insert values which are having same number of digits say, 1, 2, 3,4,5 Kilometers 2 1 4 5 2 when i try to sort now it is working perfectly Kilometers 1 2 3 4 5 Datatypes that I have tried are, Can anyone helpme to get rid out of this problem... Thanks in Advance -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-sorting-is-not-working-properly-on-long-Fields-tp4050834.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr sorting is not working properly on long Fields
Yes I did.. But there is no change in result.. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-sorting-is-not-working-properly-on-long-Fields-tp4050834p4050844.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Reverse range query
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.
Searching with min and max range in solr
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/Searching-with-min-and-max-range-in-solr-tp4039861.html
Sent from the Solr - User mailing list archive at Nabble.com.
Fetching the date based on lastupdate
Hi,
I am having a column called 'lastUpdate' in my solr which will contain
last updated date. Now i want fetch last 24 lastupdated dates from that
column. How to do this???
Querying the solr server with the following URL fetches me the result ,
http://localhost/solr/MC_10701_catalogEntry/q=lastUpdate:{* TO
NOW}&sort=lastUpdate desc
This URL will fetch the lastupdated date in descending order.
Now I want only last 24 records to be fetched. Is there any function in solr
to do this?? Plz Help me.. Thanks in advance.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Fetching-the-date-based-on-lastupdate-tp4040564.html
Sent from the Solr - User mailing list archive at Nabble.com.
