it is in the same document I gave a link to under Finding please read the whole document.
Shuchi Mehta sent the following on 9/22/2009 1:32 PM: > Sorry I was not able to understand "find query" part. I got the "widget" > part. Where do we specify "find query"? > > Thank you for the help. > Su- > > > > BJ Freeman wrote: >> 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.