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?

Parvin Gasimzade · Accepted Answer · 2012-07-09 08:56:09Z

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 9, 2012 at 8:56

Parvin Gasimzade

26.2k8 gold badges58 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mario Naether Over a year ago

Thanks, that is it. I ignored the "-" Operator

Collectives™ on Stack Overflow

How I find empty Solr document fields with lucene query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related