Answers.Body: <p>If you wanted to search for every <code>body</code> field that did <em>not</em> have a value, the syntax would be:</p>
  
  <pre><code>-body:*
  </code></pre>
  
  <p>Which basically says, give me every <code>body</code> field that has a value and negates it.  Have updated the <a href="https://craftcms.com/docs/searching#supported-syntaxes" rel="nofollow noreferrer">search docs</a> with an example.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-10T21:50:25.123Z
Answers.Text: I just noticed that the above example wont work if fuzzy search is enabled (so where "subRight" and/or "subLeft" settings are true).
Answers.UserDisplayName: BryceBubbles
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-10T22:09:28.433Z
Answers.Text: Ahh... yeah, good catch.  Not sure if I've got a solution for that one at the moment.
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-08T18:56:53.813Z
Answers.Text: This works with subRight/subLeft set to true as of Craft 3 RC5.
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-10T19:42:59.423Z
Answers.LastActivityDate: 2017-10-10T19:42:59.423Z
Answers.UserDisplayName: Brad Bell
Answers.Body: <p>We use Zenbu for this exact thing. As we're importing a lot of data, we need to find which entries are missing data - <a href="https://zenbustudio.com/software/zenbu-craftcms" rel="nofollow noreferrer">https://zenbustudio.com/software/zenbu-craftcms</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-10T08:22:24.090Z
Answers.LastActivityDate: 2017-10-10T08:22:24.090Z
Answers.UserDisplayName: JonnyT
Body: <p>In the control panel, is it possible to search for entries where a specific field is empty? The Craft <a href="https://craftcms.com/docs/searching#supported-syntaxes" rel="nofollow noreferrer">search syntax page</a> doesn't help here, and the logical values used in twig don't seem to work here. I haven't been able to find any other info about this either.</p>
  
  <p><em>Side note: the search syntax is a bit out of reach for many non-dev users (read clients). An advanced search/filter form for entries would be awesome.</em></p>
  
Tags: <entries><control-panel><search>
Title: CP search for entries where a specific field is empty
ThreadText: # CP search for entries where a specific field is empty
  
  (Asked by: username_0 on 2017-10-10)
  
  In the control panel, is it possible to search for entries where a specific field is empty? The Craft [search syntax page](https://craftcms.com/docs/searching#supported-syntaxes) doesn't help here, and the logical values used in twig don't seem to work here. I haven't been able to find any other info about this either.
  
  *Side note: the search syntax is a bit out of reach for many non-dev users (read clients). An advanced search/filter form for entries would be awesome.*
  
  **Tags:** entries, control-panel, search
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-10-10. Score: 1 | Accepted answer
  
  If you wanted to search for every `body` field that did *not* have a value, the syntax would be:
  
  ```
  -body:*
  
  ```
  
  Which basically says, give me every `body` field that has a value and negates it. Have updated the [search docs](https://craftcms.com/docs/searching#supported-syntaxes) with an example.
  
  > **Comments:**
  > **username_0**: I just noticed that the above example wont work if fuzzy search is enabled (so where "subRight" and/or "subLeft" settings are true).  
  > **username_1**: Ahh... yeah, good catch.  Not sure if I've got a solution for that one at the moment.  
  > **username_1**: This works with subRight/subLeft set to true as of Craft 3 RC5.  
  
  ---
  
  ### Answer by username_2 on 2017-10-10. Score: 1
  
  We use Zenbu for this exact thing. As we're importing a lot of data, we need to find which entries are missing data - <https://zenbustudio.com/software/zenbu-craftcms>
  
  
  ---
  
  