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.
