<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>

CC BY-SA 3.0
2017-10-10T21:50:25.123Z
I just noticed that the above example wont work if fuzzy search is enabled (so where "subRight" and/or "subLeft" settings are true).
BryceBubbles
CC BY-SA 3.0
2017-10-10T22:09:28.433Z
Ahh... yeah, good catch.  Not sure if I've got a solution for that one at the moment.
Brad Bell
CC BY-SA 3.0
2018-01-08T18:56:53.813Z
This works with subRight/subLeft set to true as of Craft 3 RC5.
Brad Bell
CC BY-SA 3.0
2017-10-10T19:42:59.423Z
2017-10-10T19:42:59.423Z
Brad Bell
<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>

CC BY-SA 3.0
2017-10-10T08:22:24.090Z
2017-10-10T08:22:24.090Z
JonnyT
<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>

<entries><control-panel><search>
CP search for entries where a specific field is empty
# 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 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>


---

