# \[DONE\] Filter by related entities fields **URL:** \ **Category:** Ideas & Features\ **Tags:** filter\ **Created:** [October 20, 2021, 7:40am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133 "2021-10-20T07:40:05Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Eugene\_Vabishchevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/eugene_vabishchevich/32/4310_2.png) [@Eugene\_Vabishchevich](https://community.fibery.io/u/Eugene_Vabishchevich)\ **Post date:** [October 20, 2021, 7:40am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/1 "2021-10-20T07:40:05Z")
Currently, if we need to filter by parent field we need to create a formula in child type and then filter by this field. It would be great to filter by parent fields without additional formulas. PS: Correct me if it’s already available to use. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [October 20, 2021, 7:44am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/2 "2021-10-20T07:44:15Z")
Can you provide a case, I don’t get the idea from the description unfortunately ---
**Author:** ![Eugene\_Vabishchevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/eugene_vabishchevich/32/4310_2.png) [@Eugene\_Vabishchevich](https://community.fibery.io/u/Eugene_Vabishchevich)\ **Post date:** [October 20, 2021, 8:01am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/3 "2021-10-20T08:01:13Z")
Ex: we have two types: “Test Cycle” (parent) and “Test Cycle Run” + a view for runs. In this view, we wanted to display only “Test Cycle Runs” where the parent “Test Cycle” has a checkbox Archived as false (to hide archived records). To achieve this, we created a formula field “Test Cycle Archived” in the “Test Cycle Run” type. And then applied a filter in the view. Basically, we created a new field to use the filter feature. We think that is a redundant step. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [October 20, 2021, 8:10am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/4 "2021-10-20T08:10:34Z")
We have this in the backlog, we call it Formulas in Filters. No ETA so far unfortunately ---
**Author:** ![Eugene\_Vabishchevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/eugene_vabishchevich/32/4310_2.png) [@Eugene\_Vabishchevich](https://community.fibery.io/u/Eugene_Vabishchevich)\ **Post date:** [October 20, 2021, 8:28am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/5 "2021-10-20T08:28:06Z")
Thanks, that is not critical due to additional formula fields. ---
**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\ **Post date:** [November 17, 2021, 4:20am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/6 "2021-11-17T04:20:22Z")
> [@mdubakov](#): > > We have this in the backlog, we call it Formulas in Filters @mdubakov I was wondering if any consideration has been given to working on this feature in conjunction with the view blocks? I know they are different things, but I think to make embedding of views really powerful and useful, the content needs to be dynamically controlled based on so inputs or variables on the page. It seems there is a logical connection between that and Formulas in Filters feature. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [November 17, 2021, 8:10am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/7 "2021-11-17T08:10:13Z")
Unfortunately no progress here. I don’t think we get to it in the next 2-3 months ---
**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:** [May 26, 2022, 12:31am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/8 "2022-05-26T00:31:00Z")
Use case for a compound filter (or formula) for a Colorizing rule: `Task.[Due date] < Today() and [Task State].Final = false` ---
**Author:** ![Martin\_Jahr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/martin_jahr/32/5969_2.png) [@Martin\_Jahr](https://community.fibery.io/u/Martin_Jahr)\ **Post date:** [December 19, 2022, 6:13pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/9 "2022-12-19T18:13:21Z")
My current use case would need a filter that can take in a formula instead of a fixed value. This way I could have boards in the left side menu that filter different items depending on a state centrally maintained elsewhere. Semantics: If company.alert = green → show all items in the to do board If company.alert = red → show only items in the to do board with todo.importance attribute == “Survival” ---
**Author:** ![HSinger](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/hsinger/32/4059_2.png) [@HSinger](https://community.fibery.io/u/HSinger)\ **Post date:** [January 24, 2023, 3:25pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/10 "2023-01-24T15:25:55Z")
It would be good to have an advanced filter mode (equation filter?): Eg. Smart folders which contain projects by department: it would be good to filter for projects that are currently active. Eg. List that contains projects by person: it would be good to filter for people with 1 or more active project ---
**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\ **Post date:** [June 8, 2023, 6:14am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/11 "2023-06-08T06:14:48Z")
We would definitely benefit from this to avoid Lookup clutter. Feel free to close [this entry](https://community.fibery.io/t/formulae-in-view-filters/4574), in case it’s a duplicate. ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 3, 2024, 11:27pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/12 "2024-01-03T23:27:28Z")
> [@mdubakov](#): > > We have this in the backlog, we call it Formulas in Filters. No ETA so far unfortunately Hey @mdubakov, assuming this is still in the backlog, is there any more of an updated ETA you could provide? It’s been a couple years since the last update on this. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 4, 2024, 3:23pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/13 "2024-01-04T15:23:55Z")
Unfortunately no updates yet. It will not be done in the next 4 months, then I can’t say… ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 4, 2024, 3:46pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/14 "2024-01-04T15:46:36Z")
Thanks for the update. It would be a very powerful feature that would remove the need for many “workarounds” for common situations, so please continue to consider it! ---
**Author:** ![Antonio\_Moura](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antonio_moura/32/10093_2.png) [@Antonio\_Moura](https://community.fibery.io/u/Antonio_Moura)\ **Post date:** [October 10, 2024, 8:45pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/15 "2024-10-10T20:45:57Z")
This would enable a numerous of AMAZING use cases. Please Fibery Team 🙏 ---
**Author:** ![Antonio\_Moura](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antonio_moura/32/10093_2.png) [@Antonio\_Moura](https://community.fibery.io/u/Antonio_Moura)\ **Post date:** [October 10, 2024, 8:48pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/16 "2024-10-10T20:48:21Z")
FYI my usecase is as follow: I want to be able to filter “Actions” that “Date - Done” field is within the range of the related “Changelog” entity “Date” field. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4c6499e002df2ee6e8caf47cbdec69c60c8c64ff.png) I think that the only way to achieve this is through formulas on filters right? ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [October 11, 2024, 6:28am UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/17 "2024-10-11T06:28:04Z")
> [@Antonio\_Moura](#): > > I think that the only way to achieve this is through formulas on filters right? Some workaround is possible. For example, you can create a Formula field that will calculate for Action whether it is in range of Changelog entity dates and set checkbox to True. Then you can just filter by this checkbox in the list ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 30, 2025, 1:59pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/18 "2025-01-30T13:59:05Z")
Released today > [@January 30, 2025 / cat Filter by related Entity's Fields, New Space Setup, Follow other users on a Whiteboard](https://community.fibery.io/t/january-30-2025-filter-by-related-entitys-fields-new-space-setup-follow-other-users-on-a-whiteboard/8194): > > ringer_planet Filter and color-code by related Entity’s Fields You can now filter Entities using fields from related databases. When setting up filters, you’ll see a new \> arrow next to relation fields, allowing you to access and filter by fields from the related database. [filter-relation] For example, if your Tasks database is connected to Teams, Epics, and Departments, you can now filter tasks using fields from any of these related databases. NOTE: Current limitations for this release: … ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 30, 2025, 3:24pm UTC](https://community.fibery.io/t/done-filter-by-related-entities-fields/2133/19 "2025-01-30T15:24:49Z")