[ https://issues.apache.org/jira/browse/OFBIZ-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13902932#comment-13902932 ]
Wei Zhang commented on OFBIZ-5377: ---------------------------------- This is really useful feature. Anybody can update on this? > 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.5#6160)