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)
