Handling join with generic foreign keys

[corneille-marechal]

Being able to make joins with GenericRelations would be nice.

[eirikbakke]

These are foreign key columns which may point to IDs in more than one table, right?

If the IDs are unique across the different tables, then in Ultorg, you can just join on the same column multiple times. Right-click the column to join on, then click Custom Join, and pick the other table to join with and its ID.

In the example below, "Resource ID" can point to globally unique IDs in either the "Users" or "Billing Accounts" tables, and joins have been added to both tables via the Custom Join action:

In Ultorg, joins work like left joins by default, so the parent row under Log Entries won't "disappear" just because there exists a join without a match.

If the IDs are not unique across tables, e.g. if an ID "100" in an other_entity_id column could be either Address number 100 or Agent number 100, depending on the value in the other_entity_type column, then you could add a formula column like this (right-click any existing column and press Insert Formula After, then edit the formula like you would in Excel)...

...and then right-click the formula column and do Custom Join on that one against the Address table (and repeat for each type of relationship).