Hi everybody,
I need some help on a query in SDK REST in Odata.
In the CRM,
A customer have some sales orders, and this sales orders avec some sales order details.
I added a field on the salesorderentity called : "last_variant"
And I need to find for a customer the max "last_variant" for all this salesorders.
How can I do that ?
*This post is locked for comments
Hi
You can use fetch xml
<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' aggregate='true'>
<entity name='account'>
<attribute name='name' />
<link-entity name='salesorder' from='parentcustomid' to='accountid' visible='false' link-type='outer' alias='a_6c61a84be522e31194080050569c4325'>
<attribute name='yourcolumnname' aggregate='max' />
</link-entity>
</entity>
</fetch>
deleted
I think you should use fetchxml as there is no aggregate functions in odata.
Refer this:
crmbusiness.wordpress.com/.../crm-2013-when-using-fetchxml-is-better-than-odata
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (