Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Not A Problem
-
None
-
None
-
None
Description
Hi,
I have issue in my server. As I stated in the subject I want to do range search query on the field (eg: filed name is “version”) which contains value like (2.5.0.1, 2.5.0.4 and 2.5.0.10 etc).
When I do range search on the “version” field with criteria [* TO 2.5.0.5], it gave me all the value like (2.5.0.1, 2.5.0.10, 2.5.0.4). But this is wrong result. Since I was expecting only 2.5.0.1 and 2.5.0.4.
But it include 2.5.0.10 with the results. I googled and found that solr does lexical sorting. But I want numerical sorting. I declared the field type as string in schema.xml.
I did the following solution but nothing worked.
• Converted the field type to number. But it gave me “NumberFormatException”. Because java does not allow multiple decimal point.
• I added left pad 0 with the value while adding document in solr. But no luck
Can you please give me good solution to come out of the issue?