RavenDB - How to convert a string field into int in a Lucene query?

Question

I am working with a bunch of documents in RavenDB that have an Age field that has to be an int but unfortunately they have been stored as string. I want to write a query to get all the docs with ages more than 20 here's what I do :

Age : [20 TO *]

But I am getting docs with ages of 3 to 9 too.(strings are compared from left hand side)

The question is how can I tell Lucene to treat age as int ?

(This system is somehow a legacy system I can't change the Age type in documents)

score 0 · Answer 1 · answered Sep 07 '14 at 10:35

0

You can use the following query:

Age_Range: [Ix20 TO *]

answered Sep 07 '14 at 10:35

Ayende Rahien

22,925
1
36
41

this way I am getting no result at all? – Beatles1692 Sep 07 '14 at 10:39
Post this in the mailing list. – Ayende Rahien Sep 07 '14 at 16:43

RavenDB - How to convert a string field into int in a Lucene query?

1 Answers1