Hi Jacques, The requirement is to define a view entity, write some additional filtering conditions in the definition itself, when this view entity is being queried in the code, these filteringconditions need not be explicitly specified. So taking the view definition in the start of this trail, when i query PartyRoleAndPersonExt from webtools like this ( http://localhost:8080/webtools/control/FindGeneric?entityName=PartyRoleAndPersonExt&find=true&VIEW_SIZE=50&VIEW_INDEX=0), the result should show details of person having role type SALES_REP only.
On Sun, Aug 15, 2010 at 3:06 PM, Jacques Le Roux < [email protected]> wrote: > 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 >> >> > -- Regards, Varun Bhansaly
