How to query Solr for empty field or specific value

Question

How to do an OR expression that filters to either blank field or a specific value?

This does not seem to do it:

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

Thanks

blank or non-existent (i.e: undefined)? – Geert-Jan Aug 14 '12 at 21:01 — Geert-Jan, Aug 14 '12 at 21:01

Jack Miller · Answer 1 · 2020-07-15T07:27:15.297

8

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

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

Note: This also works for filter queries:

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

edited Jul 15 '20 at 07:27

answered Aug 14 '17 at 12:23

Jack Miller

6,843
3
48
66

score 6 · Answer 2 · edited May 16 '19 at 00:41

6

Checkout SolrQuerySyntax

Pure Negative Queries :-

-field:[* TO *] finds all documents without a value for field

You can try :-

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

edited May 16 '19 at 00:41

d-_-b

21,536
40
150
256

answered Aug 15 '12 at 05:59

Jayendra

52,349
4
80
90

you can check http://stackoverflow.com/questions/17044661/how-to-filter-search-by-values-that-are-not-available/17045097#17045097 – Jayendra Aug 24 '13 at 14:15
A link to the very same answer. How redundant! – Jack Miller Jul 15 '20 at 07:30

score 3 · Answer 3 · answered Aug 21 '13 at 22:13

3

This should works:

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

answered Aug 21 '13 at 22:13

Артур Курицын

3,512
2
16
10

score 3 · Answer 4 · answered Jul 21 '15 at 14:11

3

This is worked for me:

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

answered Jul 21 '15 at 14:11

mrvol

2,575
18
21

score 1 · Answer 5 · edited May 23 '17 at 12:24

1

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

edited May 23 '17 at 12:24

Community

1
1

answered Dec 21 '16 at 09:00

user1533634

431
4
5

Bandham Manikanta · Answer 6 · 2020-07-15T12:36:43.147

0

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

Happy coding.

edited Jul 15 '20 at 12:36

answered May 08 '19 at 07:39

Bandham Manikanta

1,858
21
21

`**`? That is not a valid query term. – Jack Miller Jul 15 '20 at 07:34
1

* and ** both does the same job. To avoid ambiguity, I edit my answer. – Bandham Manikanta Jul 15 '20 at 12:36

How to query Solr for empty field or specific value

6 Answers6