http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling The where is in the find query. or conditionals in the widgets.
su2 sent the following on 9/22/2009 12:52 PM: > 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- > > > > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.