[jira] [Created] (OFBIZ-5377) Add ability to join entitites with parameterized conditions to other entities

[Nicolas Malin (Jira)]

Christian Carlow created OFBIZ-5377:
---------------------------------------

             Summary: Add ability to join entitites with parameterized conditions to other entities
                 Key: OFBIZ-5377
                 URL: https://issues.apache.org/jira/browse/OFBIZ-5377
             Project: OFBiz
          Issue Type: Improvement
            Reporter: Christian Carlow


OFBiz should be improved to allow entities with parameterized conditions to be joined with other entities.

I need to be able to apply a condition to the OrderShipment entity where OrderShipment.shipmentId = parameters.shipmentId which might produce this query:
SELECT * ORDER_SHIPMENT WHERE SHIPMENT_ID = '10000';

Then I need to be able to take that query and join it to the OrderItemShipGroupAssoc entity to product a query such as this:
SELECT * FROM ORDER_ITEM_SHIP_GROUP_ASSOC OISGA LEFT JOIN (SELECT * FROM ORDER_SHIPMENT WHERE SHIPMENT_ID = '10000') OS ON OISGA.ORDER_ID = OS.ORDER_ID AND OISGA.ORDER_ITEM_SEQ_ID = OS.ORDER_ITEM_SEQ_ID AND OISGA.SHIP_GROUP_SEQ_ID = OS.SHIP_GROUP_SEQ_ID



--
This message was sent by Atlassian JIRA
(v6.1#6144)