# Filter by field in related entity?

**URL:** <https://community.fibery.io/t/filter-by-field-in-related-entity/1758>\
**Category:** Get Help\
**Created:** [July 5, 2021, 7:19pm UTC](https://community.fibery.io/t/filter-by-field-in-related-entity/1758 "2021-07-05T19:19:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jim\_Larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jim_larsson/32/1489_2.png) [@Jim\_Larsson](https://community.fibery.io/u/Jim_Larsson)\
**Post date:** [July 5, 2021, 7:19pm UTC](https://community.fibery.io/t/filter-by-field-in-related-entity/1758/1 "2021-07-05T19:19:48Z")

</div>

Is there a way to filter a view by fields in related entries?  
For example: Products with UserStories where SprintStatus is current?

In the Workspace for Product Teams → app:SoftwareDevelopment → view: Current Sprint: I have set rows as Product. I wish fo filter out all Products that don’t have any Stories planed in the current sprint. It tends to clutter the view allot when you have a couple of Products that are empty.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [July 5, 2021, 7:42pm UTC](https://community.fibery.io/t/filter-by-field-in-related-entity/1758/2 "2021-07-05T19:42:54Z")

</div>

You can filter a view by whether a collection field is empty/not empty.

---

<div class="post-metadata">

**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\
**Post date:** [July 16, 2021, 7:01pm UTC](https://community.fibery.io/t/filter-by-field-in-related-entity/1758/3 "2021-07-16T19:01:01Z")

</div>

Hi, Jim!  
Matt suggesten a nice workaround.  
One more - adding a formula on the Product, that will count the number of Stories in the current sprint - and then filtering by that formula.

We have in the backlog Formula in Filters (per View) - so noted your request 💪
