How to query SOLR for empty fields

Question

I have a large solr index  and I have noticed some fields are not updated correctly  the index is dynamic    This has resulted in some fields having an empty  id  field   I have tried these queries  but they didn t work    id     id NULL  id null  id     id   id     TO      Is there a way to query empty fields   Thanks

User · Answer

you can do it with filter query q     amp fq -id

User · Answer

If you are using SolrSharp  it does not support negative queries   You need to change QueryParameter cs  Create a new parameter   private bool  negativeQuery   false   public QueryParameter string field  string value  ParameterJoin parameterJoin   ParameterJoin AND  bool negativeQuery   false        this  field   field      this  value   value Trim        this  parameterJoin   parameterJoin      this  negativeQuery   negativeQuery     public bool NegativeQuery       get   return  negativeQuery        set    negativeQuery   value        And in QueryParameterCollection cs class  the ToString   override  looks if the Negative parameter is true  arQ x     qp NegativeQuery    -            qp ToString            qp Boost    1         qp Boost ToString            When you call the parameter creator  if it s a negative value  Simple change the propertie  List lt QueryParameter gt  QueryParameters   new List lt QueryParameter gt     QueryParameters Add new QueryParameter  PartnerList       TO      ParameterJoin AND  true

User · Answer

One caveat  If you want to compose this via OR or AND you cannot use it in this form    -myfield     but you must use       NOT myfield      This form is perfectly composable  Apparently SOLR will expand the first form to the second  but only when it is a top node  Hope this saves you some time

User · Answer

You can also use it like this       fq  id     TO

User · Answer

Try this    q -id     TO

User · Answer

According to SolrQuerySyntax  you can use q -id    TO

User · Answer

If you have a large index  you should use a default value       lt field     default  EMPTY    gt    and then query for this default value  This is much more efficient than q -id     TO

[solr] How to query SOLR for empty fields?

Examples related to solr

Examples related to lucene