|
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.
|