You’re offline. This is a read only version of the page.
25
Hi there,
I am trying to apply an orderby to an aggregate query and am getting the following error message back:
{"error":{"code":"0x80041134","message":"An alias is required for an order clause for an aggregate Query."}}
I understand what the error message is saying but am unclear on how to actually resolve the issue. Here is an example of the query:
.../incidents?$filter=statecode eq 0&$groupby((statuscode), aggregate($count as total))&$orderby=statuscode desc
Regards,
Andy
Hello Andy,
please have a look in the following:
Query Data using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Docs
There are a lot of example that can help you to build your query correctly.
Thanks
Share
Report
All responses (
Answers (
