What results are you expecting and what results do you get?
Jacques
From: "varun bhansaly" <[email protected]>
Hi Jacques,
The view "surely" does not give the results. Moreover, if i look at the raw
SQL sent to db server, it doesnt include the conditions mentioned in
condition expr.
On Sun, Aug 15, 2010 at 1:32 PM, Jacques Le Roux <
[email protected]> wrote:
You say "it seems", don't the view give you the results you want?
Jacques
From: "varun bhansaly" <[email protected]>
Hi,
I have written a view entity, as shown below, the intention is to perform
inner join b/w two entities & a further condition.
But after looking at the raw SQL, it seems entity engine seems to ignore
entity condition tag.
<view-entity entity-name="PartyRoleAndPersonExt"
package-name="org.ofbiz.custom"
title="party role and party detail">
<member-entity entity-alias="PR" entity-name="PartyRole"/>
<member-entity entity-alias="PERSON" entity-name="Person"/>
<alias-all entity-alias="PR"><exclude field="partyId"/></alias-all>
<alias entity-alias="PERSON" name="personPartyId" field="partyId"/>
<alias entity-alias="PERSON" name="firstName"/>
<alias entity-alias="PERSON" name="lastName"/>
<alias entity-alias="PERSON" name="middleName"/>
<view-link entity-alias="PR" rel-entity-alias="PERSON">
<key-map field-name="partyId"/>
</view-link>
<entity-condition>
<condition-expr field-name="roleTypeId" value="SALES_REP"
entity-alias="PR"/>
</entity-condition>
</view-entity>
Am i missing anything ?
Is there any other way to specify extra conditions in the view entity
definition itself ?
--
Regards,
Varun Bhansaly
--
Regards,
Varun Bhansaly
