# BrewwQL 'total\_packaged\_beer\_quantity' help **URL:** \ **Category:** Help & advice\ **Tags:** products\ **Created:** [18 June 2024 08:58 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511 "2024-06-18T08:58:06Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![steve-neal](https://community.breww.com/user_avatar/community.breww.com/steve-neal/32/327_2.png) [@steve-neal](https://community.breww.com/u/steve-neal)\ **Post date:** [18 June 2024 08:58 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/1 "2024-06-18T08:58:06Z")
I have a brewwQl query - on the Products page, i am trying to use the `total_packaged_beer_quantity` filter - I assumed it would filter based on stock level, but does this actually filter on the number of products? E.g. Show me any beer that has more than two products, or less than 5 products, as opposed to show me products that we have more than two in stock of? Be grateful if anyone can shed any light on this. 🍻 ---
**Author:** ![jon-kyme2](https://community.breww.com/user_avatar/community.breww.com/jon-kyme2/32/1926_2.png) [@jon-kyme2](https://community.breww.com/u/jon-kyme2)\ **Post date:** [18 June 2024 09:51 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/2 "2024-06-18T09:51:00Z")
Hmmm, it seems to be something to do with the number of _Component packaged beers_ making up the product? What’s that useful for? Depending on what it is you’re trying to do, the **Products available** report might be the thing? ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [18 June 2024 09:54 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/3 "2024-06-18T09:54:24Z")
That’s correct. This field is the number of component packaged beers that make up the product. So for a 24-pack it would be 24. It has nothing to do with the stock level. ---
**Author:** ![steve-neal](https://community.breww.com/user_avatar/community.breww.com/steve-neal/32/327_2.png) [@steve-neal](https://community.breww.com/u/steve-neal)\ **Post date:** [18 June 2024 09:56 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/4 "2024-06-18T09:56:44Z")
Thanks Jon, I’ll have to use that, I thought I might be able to just make some quick filters to save me a bit of faff. ---
**Author:** ![jon-kyme2](https://community.breww.com/user_avatar/community.breww.com/jon-kyme2/32/1926_2.png) [@jon-kyme2](https://community.breww.com/u/jon-kyme2)\ **Post date:** [18 June 2024 09:57 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/5 "2024-06-18T09:57:25Z")
Ahh, so why isn’t it called component\_packaged\_beers\_number, or something? 🙂 ---
**Author:** ![steve-neal](https://community.breww.com/user_avatar/community.breww.com/steve-neal/32/327_2.png) [@steve-neal](https://community.breww.com/u/steve-neal)\ **Post date:** [18 June 2024 09:57 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/6 "2024-06-18T09:57:36Z")
Thanks for confirmation Matt. Maybe this filter could be named a little differently? Doesn’t do what I intuited at all. ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [18 June 2024 10:04 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/7 "2024-06-18T10:04:39Z")
You’re right; the name probably isn’t the most intuitive. The field was initially created just for use behind the scenes (for things such as stock calculations) and follows backend naming conventions, but then we thought it might as well be exposed to users in case it’s useful. In hindsight, we should have picked a more user-friendly name at this point! It can be a little tricky to rename them now, as it can cause issues with people already using the field (as it would no longer exist by that name), for example, but if it keeps cropping up as an issue, we can do it. ---
**Author:** ![steve-neal](https://community.breww.com/user_avatar/community.breww.com/steve-neal/32/327_2.png) [@steve-neal](https://community.breww.com/u/steve-neal)\ **Post date:** [18 June 2024 10:31 UTC](https://community.breww.com/t/brewwql-total-packaged-beer-quantity-help/4511/8 "2024-06-18T10:31:41Z")
No problem at all, the thread is here now to clear it up for anyone else that may not be getting the results they expected also. Thanks for clarifying.