In the control panel, is it possible to search for entries where a specific field is empty? The Craft search syntax page 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.

2 Answers 2


If you wanted to search for every body field that did not have a value, the syntax would be:


Which basically says, give me every body field that has a value and negates it. Have updated the search docs with an example.

  • I just noticed that the above example wont work if fuzzy search is enabled (so where "subRight" and/or "subLeft" settings are true). Commented Oct 10, 2017 at 21:50
  • Ahh... yeah, good catch. Not sure if I've got a solution for that one at the moment.
    – Brad Bell
    Commented Oct 10, 2017 at 22:09
  • This works with subRight/subLeft set to true as of Craft 3 RC5.
    – Brad Bell
    Commented Jan 8, 2018 at 18:56

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.