[SOLR-9070] how to range search on the field which contains multiple decimal point (eg: 2.5.0.4)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Component/s: search
• Assignee: Unassigned
• Reporter: Santhosh
• Created: 05/May/16 05:35
• Updated: 05/May/16 18:12
• Resolved: 05/May/16 18:12

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?