News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Nested Fetch Xml aggre...

Microsoft Dynamics CRM (Archived)

Nested Fetch Xml aggregates

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

So I want to get the top 3 of the sum of values grouped by personid. So how do I set up the xml to support the nested aggregate?

<fetch top="50" aggregate="true" >
<entity name="elcn_contributiondonor" >
<attribute name="amount" alias="amount" aggregate="sum" />

<attribute name='personid' alias='personid' groupby='true' />

</entity>
</fetch>

Does the sum of every grouped by personId I believe but where do I put a second statement to get the top 3 of these sums?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

David Jennaway 14,063 on at

Like (0)

Report
RE: Nested Fetch Xml aggregates

You should be able to do this by sorting the results by the aggregate, and using the top attribute:

<fetch aggregate="true" top="3" > <entity name="elcn_contributiondonor" > <attribute name="amount" alias="amount" aggregate="sum" /> <attribute name='personid' alias='personid' groupby='true' /> <order alias='amount' descending='true' /> </entity> </fetch>

Alternatively you could use paging to get the first 3 records, instead of top

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans