How to request Solr for an empty field or a specific value

Question

How to make an OR expression that filters an empty field or a specific value?

It doesn't look like this:

q=(-PrivacyLevel:*) OR PrivacyLevel:2

thanks

Answer 1

Checkout SolrQuerySyntax

Purely negative requests: -

-field:[* TO *] finds all documents with no field value

You can try :-

q=-PrivacyLevel:[* TO *] OR PrivacyLevel:2

Answer 2

The answer is to use the double negation proposed by Maurizio In denmark . Mathematically, this is identical to a non-rejected query, however, Solr only understands the double-negation version:

 q=-(-PrivacyLevel:2 PrivacyLevel:*) 

Note. This also works for filter queries:

 fq=-(-PrivacyLevel:2 PrivacyLevel:*) 

Answer 3

This works for me:

 fq=(* -type:[ * TO * ]) || (* +type:company) 

Answer 4

This should work:

 q=(*:* AND -PrivacyLevel:[* TO *]) OR PrivacyLevel:2 

Answer 5

See also Solr (fq) field query with AND and OR operator for potential problem and workaround with negative query.

Answer 6

The solution, q = -PrivacyLevel:(**) PrivacyLevel:("2") for me, is q = -PrivacyLevel:(**) PrivacyLevel:("2") .

Good coding.