I realised that someting I was trying to achieved would be much easier to implement with a Selector Connector added to my graph. I have studied for hours Jason Young's file and presentation but fields are not documented so I have a hard time understanding what some do and if/which critical steps must be accomplished by script for this design to work.
Jason Young's selector connector graph looks like this:
1) He doesn't put the Refresh field in right tables. I imagine that the relationship makes it unnecessary to link and add a Refresh downstream?
2) One of my right table will need to be linked to the selector but I don't have a left table occurence for it. Should i create a left TO or link it to the selector from where it sits?
3) On this graph, invoices are connected to the selectedContactID in the Selector while project is connected to the z_Connector. What is the difference? My other left tables that need to be connected to the selector, would they connect to the SelectedContactID, the z_Connector, or would they need their own nub in the Selector table?
Hello Cécile,
Let me try to answer as best I can.
>>1) He doesn't put the Refresh field in right tables. I imagine that the relationship makes it unnecessary to link and add a
>>Refresh downstream?
That's correct, for Selector Connector itself, it's the relationship from the Anchors to the upper group that often needs to be refreshed. Since with Selector Connector, the user is always working in the context of an Anchor the relationship to the Buoys is just traditional Anchor-Buoy with no additional refreshes needed.
>>2) One of my right table will need to be linked to the selector but I don't have a left table occurrence for it. Should i create a >>left TO or link it to the selector from where it sits?
This should be fine. A Buoy without an Anchor is technically an Anchor, even if on the "right." Particularly if the TO has a layout associated with it. You wouldn't be able to create a connection from both an Anchor and connected Buoy to the Selector as that would create a circular relationship, but since that's not the case here, I don't see a problem.
>>3) On this graph, invoices are connected to the selectedContactID in the Selector while project is connected to the >>z_Connector. What is the difference? My other left tables that need to be connected to the selector, would they connect to >>the SelectedContactID, the z_Connector, or would they need their own nub in the Selector table?
Ugh! That is a mistake, and I'm surprised nobody has noticed that (Good Eye!). Both the Anchor versions of Invoice and Project should be connected to z_Connector as well as any other Anchors. Since these are cross joins, everything still works, but you really want to have the cross join relationships attached to globals on both sides of the relationship for performance reasons. Cross-joins on indexed fields can be slow.
hth,
-Jason