Dynamics Community Forum Thread Details

How to retrieve top 15 total values of a field from list of opportunity records for specific month

Hi Experts,

I have a requirement to fetch top 15 values of a field for a particular month on opportunity form .

Is it possible to achieve using fetch xml ? Please suggest the best approach to implement .

Appreciate if you share the fetch xml for the same ?

Hi partner,

For example, I want to get the top 5 opportunity records order by "createdon" and were created in Oct 2019, here is the sample fetchxml

<fetch top="5" version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="opportunity">
    <attribute name="name" />
    <attribute name="customerid" />
    <attribute name="estimatedvalue" />
    <attribute name="statuscode" />
    <attribute name="opportunityid" />
      <condition attribute = 'createdon' operator='between'>
        <value>2019-10-01 00:00:00</value>
        <value>2019-10-31 23:59:59</value>
      </condition>
    <order attribute="createdon" descending="true" />
  </entity>
</fetch>