solr date between and range scan

Differences From Lucene Query Parser

Differences in the Solr Query Parser include

• Range queries [a TO z], prefix queries a*, and wildcard queries a*b are constant-scoring (all matching documents get an equal score). The scoring factors tf, idf, index boost, and coord are not used. There is no limitation on the number of terms that match (as there was in past versions of Lucene).
  • Lucene 2.1 has also switched to use ConstantScoreRangeQuery for its range queries.
• A * may be used for either or both endpoints to specify an open-ended range query.
  • field:[* TO 100] finds all field values less than or equal to 100
  • field:[100 TO *] finds all field values greater than or equal to 100
  • field:[* TO *] matches all documents with the field
• Pure negative queries (all clauses prohibited) are allowed.
  • -inStock:false finds all field values where inStock is not false
  • -field:[* TO *] finds all documents without a value for field
• A hook into FunctionQuery syntax. Quotes will be necessary to encapsulate the function when it includes parentheses.
  • Example: _val_:myfield
  • Example: _val_:"recip(rord(myfield),1,2,3)"
• Nested query support for any type of query parser (via QParserPlugin). Quotes will often be necessary to encapsulate the nested query if it contains reserved characters.
• Example: _query_:"{!dismax qf=myfield}how now brown cow"
• Although not technically a Syntax difference, please note that if you use the Solr "DateField" type, any queries on those fields (typically range queries) should use either the Complete ISO 8601 Date syntax that field supports, or the DateMath Syntax to get relative dates. Examples:
  • timestamp:[* TO NOW]
  • createdate:[1976-03-06T23:59:59.999Z TO *]
  • createdate:[1995-12-31T23:59:59.999Z TO 2007-03-06T00:00:00Z]
  • pubdate:[NOW-1YEAR/DAY TO NOW/DAY+1DAY]
  • createdate:[1976-03-06T23:59:59.999Z TO 1976-03-06T23:59:59.999Z+1YEAR]
  • createdate:[1976-03-06T23:59:59.999Z/YEAR TO 1976-03-06T23:59:59.999Z]
  NOTE: TO must be uppercase, or Solr will report a 'RANGE_GOOP' error.

http://wiki.apache.org/solr/