CRM Fetch report

//fetch 格式  (enableprefiltering="1" prefilterparametername="CRM_Filteredxd_productionbudget" 过滤条件)
<fetch mapping="logical">
  <entity name="xd_productionbudget"  enableprefiltering="1" prefilterparametername="CRM_Filteredxd_productionbudget">
    <attribute name="xd_crop"  alias="xd_crop"/>
    <attribute name="xd_property"  alias="xd_property"/>
    <link-entity name="xd_productioncostallocation" to="xd_productionbudgetid" from="xd_productionbudget" link-type="inner">
      <attribute name="xd_costallocation"  alias="xd_costallocation"/>
      <attribute name="xd_totalbudget"  alias="xd_totalbudget"/>
      <attribute name="xd_totalactual"  alias="xd_totalactual"/>
      <attribute name="xd_averagebudgetperhactare"  alias="xd_averagebudgetperhactare"/>
      <attribute name="xd_averageactualperhactare"  alias="xd_averageactualperhactare"/>
    </link-entity>
    <link-entity name="xd_property" to="xd_property" from="xd_propertyid" link-type="inner">//实体之间的连接查询
      <attribute name="xd_company"  alias="xd_company"/>
    </link-entity>
  </entity>
</fetch>

posted @ 2014-01-16 16:36  Bill 李  阅读(204)  评论(0编辑  收藏  举报