search

rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
134 stars 55 forks source link

Layout XML possibly invalid when using aggregations on linked table #1057

Closed taylordgordon closed 1 month ago

taylordgordon commented 1 month ago

This view (made by FetchXMLBuilder) does not show correctly in the UI... maybe it has to do with my link-entities or the aggregation?

FetchXml from the builder: `

`

LayoutXML from the builder: `

`

What is shown in interface: image

The query returns data and is perfect in FetchXMLBuilder. I can see the data returned to the browser in devtools, but it won't display in UI.

If I change the layoutXML manually to the logical names of the group-by attributes, the column names do show up - but still no data rows appearing. Regardless, I am still unsure how to properly refer to my two aggregate columns "LoansClosed" and "LatestCloseDate". image

Resulting in this, despite there being 1 row evident in browser devtools: image

rappen commented 1 month ago

Maybe I've been offline too long, but to my knowledge, the aggregate queries are not allowed (or not supported) in Views. Am I wrong? If so, can you send me a link to MS Docs? I want to learn... :)

taylordgordon commented 1 month ago

I am pretty sure you are not wrong Jonas, I tried a lot of things without success, and can't find any documentation saying it is supported. It would be handy though, so we can do simpler aggregations in Views without PBI. Probably a risk to performance though.

Cheers!