How I find empty Solr document fields with lucene query

Question

i have some documents like this:

<doc>
  <str name="navTitle"/>
  <str name="title">Word 1</str>
</doc>
<doc>
  <str name="navTitle">Word 2</str>
  <str name="title">Word 3</str>
</doc>

and i will find all documents with an emtpy "navTitle" field! How is the lucene query for this?

I trying " navTitle:'' " and I trying " navTitle:' ' ", but the Solr Admin Panal find nothing. Whats wrong at the query?

score 13 · Accepted Answer · answered Jul 09 '12 at 08:56

13

In the SolrQuerySytax page they says that you can use the following query to find all empty queries.

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

answered Jul 09 '12 at 08:56

Parvin Gasimzade

25,180
8
56
83

2

Thanks, that is it. I ignored the "-" Operator – Mario Naether Jul 09 '12 at 14:18

How I find empty Solr document fields with lucene query

1 Answers1

Linked