In the OFBiz trunk there is an option for view-entity definitions to
include an entity-condition element that is similar to the ones in
simple-method and various widgets, and that will allow you to add a
where condition to the view-entity def.
-David
On Sep 22, 2009, at 1:52 PM, su2 wrote:
Hello Friends,
I would like to create a view entity for entity "orderheader" and
"orderContactMech". I want to have that to represent following SQL.
---------------------------------------------------------------------------------------------------
SELECT orderheader.orderId, orderheader.orderDate,
orderContactMech.contactMechId
FROM orderheader OUTER JOIN orderContactMech ON orderheader.orderId =
orderContactMech.orderId
WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
---------------------------------------------------------------------------------------------------
I have idea how to create view entity without WHERE clause. But not
sure how
to add WHERE clause.
I appreciate the help.
Thanks in advance.
Su-
--
View this message in context:
http://www.nabble.com/View-entity-with-WHERE-clause-tp25530883p25530883.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
