Isnull equivalent in SOLR

Question

My query in sql server is like where isnull(id,'3') = 3 which would give me all null values as well as values equal to 3. I want to achieve the same in SOLR but not able to get it. I tried

id:3 OR -id:[* TO *]

but it gave me no result whereas on -id:[* TO *] it gives me correct amount of results. How do I make the query?

score 2 · Accepted Answer · answered Jun 10 '15 at 09:14

2

maybe the issue here is the precedence of the operators, - is being applied to both condition or something like that (might be a bug), anyway, this works:

q=(-id:[* TO *]) OR id:3

answered Jun 10 '15 at 09:14

Persimmonium

15,593
11
47
78

score 0 · Answer 2 · edited Nov 23 '20 at 04:15

0

try with id:('' TO *) OR id:3.

edited Nov 23 '20 at 04:15

Hitesh

3,449
8
39
57

answered Dec 07 '16 at 17:11

Piyush_Rana

305
3
15

Isnull equivalent in SOLR

2 Answers2