Hi Jacques, I forgot to mention, I am using https://svn.apache.org/repos/asf/ofbiz/branches/release09.04 at rev 934744. In this ModelViewEntity does not consider "entity-condition", so while this is still a valid view entity definition, the engine ignores "entity-condition". With the latest 10.04 trunk ModelViewEntity contains the parsing logic for "entity-condition".
Thanks for helping me solve this (on a sunday !) partly. Now I need to find a way to easily patch these changes into my 09.04 codebase. On Sun, Aug 15, 2010 at 4:11 PM, Jacques Le Roux < [email protected]> wrote: > With your initial definition It works for me, I get the details (as definef > in your view: names) of persons with role type SALES_REP only > What is missing in your results? > > And also what do you mean when you say <<when this view entity is being > queried in the code, these filteringconditions need not be explicitly > specified.>>, what to you attempt to do at this moment? > > > Jacques > > > From: "varun bhansaly" <[email protected]> > >> 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 >> >> > > -- Regards, Varun Bhansaly
