I have an object type that could possibly benefit from self link types.
The use case is in one object type “experiment” 1 experiment object can have 2 “solutions” (a column with list of solution ids) and each of the 2 solutions could also be an “experiment” object. So I think self link could be the answer for this problem instead of creating two different object types.
Any suggestions?
Hello!
In order to create a self referential link type, you can do that similar to how you would create any other link type. In this particular example, you could for instance have a the solution property be a a string array that would reference the primary key of your existing Experiment object type. When you set up your link type you can set it up so that Experiment has this foreign key to Experiment
Thank you @vhellem for the idea.
I was not aware that we can have links on array columns.
At least the first step of linking the object type to itself and maybe to others using string array is solved.