View entity extra conditions

[varun bhansaly]

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