Hi All, we have any option to GROUPBY the records based on link-entity? I am working on a requirement where I need to group by the results based on the link entity attribute. Below is the Fetch XML I am using.
When I am using groupby="true" getting Liquid error: Exception has been thrown by the target of an invocation.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="PRIMARYENTITY">
<attribute name="PRIMARYENTITYid" />
<attribute name="PRIMARYENTITYNAME" />
<link-entity name="SECONDARYENTITY" from="SECONDARYENTITYid" to="SECONDARYENTITY" link-type="inner" alias="ap">
<attribute name="SECONDARYENTITY_name" groupby="true"/>
<filter type="and">
<condition attribute="SECONDARYENTITYid" operator="eq" uitype="SECONDARYENTITY" value="{2D1C78B9-237A-EC11-8D21-000D3A5BB4A6}" />
</filter>
</link-entity>
</entity>
</fetch>
