: The issue I have is that some promotions are permanent so they don't have : an endDate set. : : I tried doing: : : ( +Promotion.endDate:[20000101000000TOvariable containing yesterday's date] : || -Promotion.endDate:* )
1) mixing prefix ops with "||" like this is most certainly not doing what you think... https://lucidworks.com/blog/why-not-and-or-and-not/ 2) combine that with Ahmet's point about needing a "MatchAllDocsQuery" to "select all docs" from which you can thin "exclude docs with an endDate" to give you the final results of "docs w/o an endDate" ... BooleanQuery( Should(NumericRangeQuery("endDate:[X TO Y]")) Should(BooleanQuery( Must(MatchAllDocsQuery()) MustNot(FieldValueQuery("endDate")) )) ) ...either that, or index a new boolean field "permenant" and then simplify your query to basically just be "endDate:[X TO Y] OR permentant:true" -Hoss http://www.lucidworks.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org For additional commands, e-mail: java-user-h...@lucene.apache.org