Linked Object enhancements
Two improvements to the "Linked Objects" window in visual query designer:
1. Show column name(s) for each associated object.
For example:
[Person]
PersonID
PersonName
MotherID
FatherID
In the "Add Linked Object" window, it would be useful to see
Person (MotherID --> Person.PersonID)
Person (FatherID --> Person.PersonID)
This makes it easier to understand the associations, as well as choose the correct one in the case where you have multiple joins to the same entity.
2. Provide a "multi-select" checkbox on the left side of the list; so, if I have 10 associated tables and I want to join 5 of them, I can just check their boxes rather than having to open the popup 5 times.
1. Show column name(s) for each associated object.
For example:
[Person]
PersonID
PersonName
MotherID
FatherID
In the "Add Linked Object" window, it would be useful to see
Person (MotherID --> Person.PersonID)
Person (FatherID --> Person.PersonID)
This makes it easier to understand the associations, as well as choose the correct one in the case where you have multiple joins to the same entity.
2. Provide a "multi-select" checkbox on the left side of the list; so, if I have 10 associated tables and I want to join 5 of them, I can just check their boxes rather than having to open the popup 5 times.
Hello,
Can it be that metadata isn't loaded completely at the moment when you create your query? You can learn if the metadata is loaded or not by the Refresh Metadata toolbox button (Two arrows are going by circle) replaced with the Stop Metadata Loading button (red sign with a cross)