How can I ask Solr for a field which is either empty or has a distinct value

Question

I need to get all documents where field 'status' is either empty or has the value 'active'

I tried

status:active OR (NOT status:*)
status:active OR (NOT status:[* TO *])
status:(active OR NOT *)

All of these variants don't work.

score 0 · Answer 1 · answered Aug 23 '12 at 17:12

0

Try this one

-status:[* TO *] OR status:active

answered Aug 23 '12 at 17:12

udalmik

Unfortunately, zero results. Each of the terms works as expected, but when combined with OR, it looks like they are combined with AND in fact. – valeryz Aug 23 '12 at 17:27
Hmm... maybe (-status:[* TO *] OR status:active)? – udalmik Aug 23 '12 at 17:31
Tried this too, doesn't work. I will probably amend the field at index time so that it is not empty. – valeryz Aug 23 '12 at 19:06
The above query is correct though. Not sure why it is not working for you. e.g. q=-status:[* TO *] OR status:active. The fields should be indexed and it should work fine. – Jayendra Aug 24 '12 at 06:45

score 0 · Answer 2 · answered Aug 24 '12 at 06:34

0

Try the following query.

-(status:['' TO *] OR -status:active)

answered Aug 24 '12 at 06:34

Parvin Gasimzade

score 0 · Answer 3 · edited May 23 '17 at 12:31

0

status:active OR (*:* NOT status:["" TO *])

I never got the -status versions to work.

edited May 23 '17 at 12:31

Community

answered Feb 26 '16 at 08:54

neu242

3 Answers3