search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.84k stars 1.5k forks source link

[BUDI-7798] Allow relationships within the same table #3498

Open marco-santulli opened 2 years ago

marco-santulli commented 2 years ago

creating a relationship over the same table is a valid/frequent use case. Imagine a contractor/subcontractor relationship. They are both contractors.

I have seen this implemented differently in other products (directus / nocodb), it might be good to allow the developer to use columns in a third table provide the mapping between the two tables. Currently I think only a foreign key column in the end-table is allowed.

This is the current user experience, the same happens in the budibase DB and external sources:

image

From SyncLinear.com | BUDI-7798

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

santossg commented 1 year ago

Is this solved? I want to use a relationship within the same table. Please let me know if there is a silution.

arpadgabor commented 1 year ago

Any chance of this getting some love? I want to create parent/child relationships and it would be awesome to have this possibility out of the box.

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity.

pmankow commented 1 year ago

This is necessary. I want it as well.

arpadgabor commented 9 months ago

Hi, I totally understand the need to close issues that are not planned and I also understand there probably are more important problems to solve. However I'd like to ask, if possible, why is the feature not planned? (complexity, few requests?) or maybe we can get an answer about any workarounds we don't know of?

pmankow commented 9 months ago

I agree. I really don't understand how it can be avoided. At least it would be nice if you could provide a functional/logical workaround or note on how implementing this violates the design philosophy of the product. This is why I abandoned the product after having done a fair bit of development on a PLM system with it.

melohagan commented 9 months ago

Sorry closed by accident!

leolivier commented 8 months ago

I need that too!

L42xyz commented 7 months ago

I need that as well. I have a contact table where people can be sponsor of other people and I am currently stuck. Thanks in advance