Linked Object enhancements

Avatar
  • updated
  • Completed
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.

Avatar
Anonymous
Hello,

Thank you for your suggestions. 

The first suggestion will be implemented in the next version that will be released next week.

We will consider the second suggestion for implementation in one of the next minor versions.
Avatar
Anonymous
First suggestion is implemented now.
Avatar
Trevor Gould
Thanks for this!
I see you marked the ticket as closed....do you plan to implement the 2nd part?
Avatar
Anonymous
You are right. We do not plan to implement the second part in the near future. 
Avatar
Anonymous

Is there some setting to get the linked objects to work? I get automatic links when using the ActiveQuery Builder in our product but not when using the FlySpeed SQL product. I have to manually link.

Avatar
Anonymous

Please send me a screenshot of your Connection Properties dialog.

Avatar
Anonymous

Also the General tab please

Avatar
Anonymous

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)