How to write a solr query for retrieving all records with numeric field value less then specified?

java syntax solr lucene solrj
Roman picture Roman · Dec 30, 2011 · Viewed 22.8k times · Source

Let's assume we have a set of mp3-players with names and prices.

How to write a correct solr query for finding all goods with a certain name and with price less then 100$?

q = "(name:(ipod) AND price ???? 100.0)"

Answer

Eser Aygün picture Eser Aygün · Dec 30, 2011

I don't think the query parser supports < operator. You have to define a RangeQuery explicitly. You can then attach a name query to that using a BooleanQuery.

Update: Apparently, I was wrong. In fact, Solr's query parser is smarter than Lucene's. Here is your answer: https://lucene.apache.org/solr/guide/8_0/the-standard-query-parser.html#differences-between-lucene-s-classic-query-parser-and-solr-s-standard-query-parser

field:[* TO 100] finds all field values less than or equal to 100

Related questions

Is there a goto statement in Java?

I'm confused about this. Most of us have been told that there isn't any goto statement in Java. But I found that it is one of the keywords in Java. Where can it be used? If it can not be …

Read More
Java switch statement multiple cases

Just trying to figure out how to use many multiple cases for a Java switch statement. Here's an example of what I'm trying to do: switch (variable) { case 5..100: doSomething(); break; } versus having to do: switch (variable) { case 5: case 6: etc. case 100: …

Read More
Is there a difference between x++ and ++x in java?

Is there a difference between ++x and x++ in java?

Read More