Searching for date range or null/no field in Solr

Question

I want to perform a search on a text field in Solr. I want to return all matches in a range or where there is no value. The two searches word independently:

myfield:[start TO finish]
-myfield:[* TO *]

The first returns all matches in the range. The second returns all matches that have no value for the "myfield" field. The problem is combining these two.

This returns no matches:

myfield:[start TO finish] OR -myfield:[* TO *]

This returns matches between start and finish, but not null entries:

myfield:[start TO finish] OR (-myfield:[* TO *])

Answer 1

Try this.