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

["David Smiley (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-9070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Smiley closed SOLR-9070.
------------------------------
    Resolution: Not A Problem

> how to range search on the field which contains multiple decimal point (eg: 2.5.0.4)
> ------------------------------------------------------------------------------------
>
>                 Key: SOLR-9070
>                 URL: https://issues.apache.org/jira/browse/SOLR-9070
>             Project: Solr
>          Issue Type: Improvement
>          Components: search
>            Reporter: Santhosh
>
> 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?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org