3
Filter by One-to-Many Relations
Source: twentyhq/twenty#10488 · opened by @unknown
We're able to filter by one-to-one _and_ many-to-one relations, but not one-to-many.
For example, if the Deals table has a one-to-many relation to Funders:
<img width="535" alt="Screenshot 2025-02-25 at 11 43 36 AM" src=" />
And a one-to-one relation to Offers:
<img width="535" alt="Screenshot 2025-02-25 at 11 43 48 AM" src=" />
Then a Deals view will contain "Queued Funders" in its filter dropdown, but not "test":
<img width="1920" alt="Screenshot 2025-02-25 at 11 41 49 AM (2)" src=" />
However, a Funders view _will_ contain "Queued Deal" in its filter dropdown (because it's many-to-one):
<img width="1920" alt="Screenshot 2025-02-25 at 11 46 37 AM (2)" src=" />
Would love the ability to filter by one-to-many relations.
For example, if the Deals table has a one-to-many relation to Funders:
<img width="535" alt="Screenshot 2025-02-25 at 11 43 36 AM" src=" />
And a one-to-one relation to Offers:
<img width="535" alt="Screenshot 2025-02-25 at 11 43 48 AM" src=" />
Then a Deals view will contain "Queued Funders" in its filter dropdown, but not "test":
<img width="1920" alt="Screenshot 2025-02-25 at 11 41 49 AM (2)" src=" />
However, a Funders view _will_ contain "Queued Deal" in its filter dropdown (because it's many-to-one):
<img width="1920" alt="Screenshot 2025-02-25 at 11 46 37 AM (2)" src=" />
Would love the ability to filter by one-to-many relations.
No pledges yet. Be the first to back this.
Comments
Similar requests
Missing Sorting Functionality for Related Records in Object Relations
6 votes · 0 comments
ONE_TO_MANY relation filter support — design proposal
5 votes · 0 comments
Add graph mode for mapping relationships
2 votes · 0 comments
App sync fails when an app declares a relation to a custom object owned by another app ("has no relation target object metadata")
0 votes · 0 comments
Create RelationFilterMetadata
2 votes · 0 comments
No comments yet.