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-
