Query to omit rows with empty records

Question

How do you omit rows with empty records in Solr? I've tried a few permutations but nothing seems to be working:

1: "John", "blue", "dog" 2: "Sue", "brown", "zebra" 3: "Mike", "red", "" <--do not return this row with the results 4: "Jen", "green", "cat"

Answer 1

esp:[* TO *] restricts to documents which contain esp field, so your query could be like:

q=esp:[* TO *]&fq=enu:open