# Need help with BrewQL search string

**URL:** <https://community.breww.com/t/need-help-with-brewql-search-string/6382>\
**Category:** Help & advice\
**Created:** [6 October 2025 12:13 UTC](https://community.breww.com/t/need-help-with-brewql-search-string/6382 "2025-10-06T12:13:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\
**Post date:** [6 October 2025 12:13 UTC](https://community.breww.com/t/need-help-with-brewql-search-string/6382/1 "2025-10-06T12:13:17Z")

</div>

In the custom reporst section I want to filter out all the containers with the following criteria:

- Location: Brewery.Main
- Code contains KU\*
- is not empty
- is not with customer

The not empty part of the string is giving me difficulty.

```auto
code ~ "KU" and current_location.site.name = "Brewery" and current_racking.container.empty_at_brewery = False

```

Throws me “ **There was a problem with the BrewwQL. Please double-check that it is valid. You are filtering on Container data having already traversed away from it. This is likely a mistake and will not return the data you are expecting. You can likely simplify your filter to achieve what you would like.”**

This doesn’t make sense - any suggestion what is going wrong?

I also haven’t figured out a good way to filter the “not with customer” bit

---

<div class="post-metadata">

**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\
**Post date:** [6 October 2025 12:31 UTC](https://community.breww.com/t/need-help-with-brewql-search-string/6382/2 "2025-10-06T12:31:41Z")

</div>

EDIT: OP was about the containers section of breww - as I need to export it to csv I need it as a custom report

---

<div class="post-metadata">

**Author:** ![ben-collard](https://community.breww.com/user_avatar/community.breww.com/ben-collard/32/1560_2.png) [@ben-collard](https://community.breww.com/u/ben-collard)\
**Post date:** [8 October 2025 10:07 UTC](https://community.breww.com/t/need-help-with-brewql-search-string/6382/3 "2025-10-08T10:07:12Z")

</div>

Hi Gijs,

Thanks for your comment! I’ve had a look at this, and it sounds like the following filter should give you what you need:

```auto
current_location.site.name = "Brewery" and current_location.name = "Main" and code ~ "KU" and empty_at_brewery = False and current_customer = None

```

Let me know if you need any more support with this. Cheers!