Hello,
I am trying to implement a subgrid on a form that displays related records but only shows the distinct rows. I am using FetchXML Builder in XrmToolbox, and have a very simple fetchxml:
<fetch distinct="true">
<entity name="ptl_sponsorship">
<attribute name="ptl_sponsor" />
<order attribute="ptl_sponsor" descending="false" />
</entity>
</fetch>
This works properly i.e.displays only the distinct rows within FetchXML Builder but incorrectly shows ALL rows in the subgrid.
Does custom fetchxml work in subgrids in D365?
Thanks!
