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 applied, the find method could be used.
Does anyone know if EntityCondition can be associated with an Entity
without the query being executed?
On 10/30/2013 11:53 AM, Christian Carlow wrote:
> 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.
>
Locked
