definition of view entity

[Martin Kaiser <ma...@martin-kaiser.info>]

Hi all,

I've constructed an view entity in entitymodel.xml. It should give me an
address related to a party, and also the person and group name.
Unfortunately it gives me also the addresses which have are expired by
setting the thrudate. I still want the Party/Person/Group information to be
in the entity but not the address data. Does anyone have an idea?

Many thanks for your help.

Best regards,
Martin

<view-entity entity-name="MyFindAllView" package-name="ch.test">
 <member-entity entity-alias="party" entity-name="Party"></member-entity>
<member-entity entity-alias="person" entity-name="Person"></member-entity>
 <member-entity entity-alias="partyGroup"
entity-name="PartyGroup"></member-entity>
<member-entity entity-alias="address"
entity-name="PartyAndPostalAddress"></member-entity>
 <alias-all entity-alias="party"></alias-all>
<alias-all entity-alias="person">
 <exclude field="comments"/>
</alias-all>
<alias-all entity-alias="partyGroup">
 <exclude field="comments"/>
</alias-all>
<alias entity-alias="address" name="address1"></alias>
 <alias entity-alias="address" name="city"></alias>
<alias entity-alias="address" name="fromDate"></alias>
 <alias entity-alias="address" name="thruDate"></alias>
<view-link entity-alias="party" rel-entity-alias="person"
rel-optional="true">
 <key-map field-name="partyId" rel-field-name="partyId"/>
</view-link>
 <view-link entity-alias="party" rel-entity-alias="partyGroup"
rel-optional="true">
<key-map field-name="partyId" rel-field-name="partyId"/>
 </view-link>
<view-link entity-alias="party" rel-entity-alias="address"
rel-optional="true">
 <key-map field-name="partyId" rel-field-name="partyId"/>
</view-link>
 </view-entity>

Re: definition of view entity

[SAURABH SINGH <sa...@gmail.com>]

Hi
    Always try to not use alias-all in in views entity only select the
field so you will get the selected data only
and the query time will be less so that we can get data quickly form any
view entity..


On Sat, Jun 8, 2013 at 6:14 PM, Martin Kaiser <ma...@martin-kaiser.info>wrote:

> Hi all,
>
> I've constructed an view entity in entitymodel.xml. It should give me an
> address related to a party, and also the person and group name.
> Unfortunately it gives me also the addresses which have are expired by
> setting the thrudate. I still want the Party/Person/Group information to be
> in the entity but not the address data. Does anyone have an idea?
>
> Many thanks for your help.
>
> Best regards,
> Martin
>
> <view-entity entity-name="MyFindAllView" package-name="ch.test">
>  <member-entity entity-alias="party" entity-name="Party"></member-entity>
> <member-entity entity-alias="person" entity-name="Person"></member-entity>
>  <member-entity entity-alias="partyGroup"
> entity-name="PartyGroup"></member-entity>
> <member-entity entity-alias="address"
> entity-name="PartyAndPostalAddress"></member-entity>
>  <alias-all entity-alias="party"></alias-all>
> <alias-all entity-alias="person">
>  <exclude field="comments"/>
> </alias-all>
> <alias-all entity-alias="partyGroup">
>  <exclude field="comments"/>
> </alias-all>
> <alias entity-alias="address" name="address1"></alias>
>  <alias entity-alias="address" name="city"></alias>
> <alias entity-alias="address" name="fromDate"></alias>
>  <alias entity-alias="address" name="thruDate"></alias>
> <view-link entity-alias="party" rel-entity-alias="person"
> rel-optional="true">
>  <key-map field-name="partyId" rel-field-name="partyId"/>
> </view-link>
>  <view-link entity-alias="party" rel-entity-alias="partyGroup"
> rel-optional="true">
> <key-map field-name="partyId" rel-field-name="partyId"/>
>  </view-link>
> <view-link entity-alias="party" rel-entity-alias="address"
> rel-optional="true">
>  <key-map field-name="partyId" rel-field-name="partyId"/>
> </view-link>
>  </view-entity>
>



-- 
*Thanks & Regards
SAURABH SINGH
**Software Engineer*