How to display Opportunity-Count on Account view

• 20 Mayıs 2012 Pazar 17:23

   

   
  

  0

  Hi,

  In the CRM 2011 SDK, I found the way to 'WorkWithViews', where we can add a custom view with a .Net program. So I tried to create a view that uses the following FetchXML to display the aggregate field for OpportunityCount in the Account entity view: -

  <fetch mapping='logical' aggregate='true'>
    <entity name='account'>
      <attribute name='name' alias='Account' groupby='true' />
      <link-entity name='opportunity' alias='Oppty' from='customerid' to='accountid' link-type='outer'>
        <attribute name='name' alias='OpptyCount' aggregate='countcolumn' />
      </link-entity>
    </entity>
  </fetch>

  The FetchXML works fine in the FetchXML-Query-Designer, but when used in the .Net program, gives error on the layoutXml of SavedQuery.

  If anyone has achieved this, kindly share the .Net code part that builds the layoutXml and fetchXml for the SavedQuery

  Thanks in advance :-)
  \Ajay

  ---

  \Ajay

  • Yanıt
  • Alıntı