findby can be used in minilanq, and java, which includes the bsh \framework\entity\dtd\entitymodel.xsd has all the current capablities. since your using 4.0 you will have to see since I don't use it any more.
Shuchi Mehta sent the following on 9/22/2009 1:48 PM: > Thank you. And apologize for being little impatient. > > I read the document, and what I understood is Finding (findByAnd) method > is used in .bsh file. So, I just want to make sure that there is no way > to specify "WHERE" clause while creating the <view-entity>. correct? > > Again, thanks for your help. > Shuchi- > > BJ Freeman wrote: >> 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.