Anyone know a way to apply condition to view-entity and then left join to another view-entity?

2013-10-30 Thread Christian Carlow
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

Re: Anyone know a way to apply condition to view-entity and then left join to another view-entity?

2013-10-30 Thread Todd Thorner
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,

Re: Anyone know a way to apply condition to view-entity and then left join to another view-entity?

2013-10-30 Thread Christian Carlow
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

Re: Anyone know a way to apply condition to view-entity and then left join to another view-entity?

2013-10-30 Thread Christian Carlow
It seems like WHERE clauses should be able to be associated with an entity/view-entity other than in find methods such as findByAnd or findListIteratorByCondition. This would allow the where clause to be applied to the query without the query being executed. Once the where clauses are