How To Or Null Value In Apache Solr Query?

The last option to solve this for me was to ask StackOverflow. I am trying to create a Solr query to get documents that have a specific value on one of its fields OR that does not

Solution 1:

(-name:[* TO *] AND *:*) OR name:john

Solution 2:

You can also use it like this.

&fq=name:john OR !name:['' TO *]

Solution 3:

you can use below to get results which is null and rest

-name:[* TO *] OR *:*

Solution 4:

try the below query -

q=(name:john OR -(name:[* TO *]))