Hey Todd,
Thanks for trying to help but your link is specific to Magento and it
doesn't cover the problem I face.
I need to be able to apply a condition to the OrderShipment where
OrderShipment.shipmentId = parameters.shipmentId which might product
this query:
SELECT * FROM ORDER_SHIPMENT WHERE SHIPMENT_ID = '10000';
Then I need to be able to left join that query to another to produce
something like 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
Anyone know if this is possible? If not I'll create an Improvement
Issue on JIRA to add such functionality.
On 10/30/2013 11:36 AM, Todd Thorner wrote:
I'm very new to OFbiz and very rusty at MVC programming (haven't done
any since Struts 1.x), but I bumped into this page when I was
researching ecommerce front-ends:
http://www.magentocommerce.com/boards/viewthread/33703/
Not sure if that has anything to do with what you're trying to
accomplish, but I thought I'd try pretending to help. As people might
be able to guess, I'm quite lost so far.
Todd
P.S. to everyone on the board: I hope to learn enough about OFbiz to
pitch in with documentation. I have 15+ years experience as a tech
writer, mostly doing API docs for SDK products. At the rate I'm getting
up to speed, it shouldn't take me more than a few years...
On 13-10-30 08:56 AM, Christian Carlow wrote:
Does anyone know a way to apply a condition to a view-entity and then
left join it to another view-entity?
I need to be able to apply a condition to the OrderShipment entity where
shipmentId = parameters.shipmentId and then left join this conditioned
view-entity to another view-entity.
I couldn't figure out how to do it with DynamicViewEntity.