Hi, Thanks for ur reply, entity alias is already being used in the condition expr, further using rel-optional = true results in Left Outer Join whereas rel-optional = false (which is default) results in inner join.
On Sun, Aug 15, 2010 at 12:32 PM, Ravindra Mandre <[email protected]>wrote: > Hi, > Comments inline > > > On Sun, Aug 15, 2010 at 11:53 AM, varun bhansaly <[email protected] > >wrote: > > > 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"/> > > > > > try by providing entity-alias name on which you are making condition > , and rel-optional="true" in view link > > HTH > > Ravindra Mandre > > > > > > > </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
