21
votes

I want in 2nd part of my query to have a list of result for while data not null. I find how do it in solr but not in lucene. Anyone have a idea Thanks

String :

( field_one:search AND field_two:3000) OR (field_three:search AND field_two:3000 AND NOT NULL field_one )

Query:

+field_one:search +field_two:3000 +field_three:search +field_two:3000 -field_one:null

3
Possible duplicate of Lucene not null query?dcorking

3 Answers

22
votes
*:*  -MY_FIELD_NAME:[* TO *] 

The above should do it, note the * : * for Lucene.

5
votes
*:* -MY_FIELD_NAME:[* TO "zzzzzzzzzz"]

You can add more "z" chars to ensure to include any value of the field.