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.
Can you provide a case, I don’t get the idea from the description unfortunately
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.
We have this in the backlog, we call it Formulas in Filters. No ETA so far unfortunately
5 Likes
Thanks, that is not critical due to additional formula fields.
@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.
Unfortunately no progress here. I don’t think we get to it in the next 2-3 months
Use case for a compound filter (or formula) for a Colorizing rule:
Task.[Due date] < Today() and [Task State].Final = false
4 Likes
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”
1 Like
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
1 Like
We would definitely benefit from this to avoid Lookup clutter.
Feel free to close this entry, in case it’s a duplicate.
1 Like
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.
1 Like
Unfortunately no updates yet. It will not be done in the next 4 months, then I can’t say…
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!
2 Likes
This would enable a numerous of AMAZING use cases.
Please Fibery Team 
1 Like
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.
I think that the only way to achieve this is through formulas on filters right?
1 Like
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
Released today