How to create an Outer Join using DynamicViewEntity

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

How to create an Outer Join using DynamicViewEntity

Stephen Rufle-2
I am currently using
        dynamicView.setEntityName("Product");
         dynamicView.addMemberEntity("P", "Product");
         dynamicView.addMemberEntity("I", "InventoryItem");
to join Product and InventoryItem

We would like to create an additional PartyProductAssociation table with
partyId and productId as a combined primary key. This would be so we can
lookup products by the customers alternate productId.

So I would like to add an outer join. But an not sure that this is
  dynamicView.addMemberEntity("I", "PartyProductAssociation ");
  dynamicView.addRelation("one-nofk", "", "PartyProductAssociation",
ModelKeyMap.makeKeyMapList("productId"));
  dynamicView.addRelation("one-nofk", "", "PartyProductAssociation",
ModelKeyMap.makeKeyMapList("partyId "));

Correct.

Any help would be appropriated. If some of this is covered in either
docs or in the training videos tell me that too.