fetchxml aggregate function

(0) Share

Report

Posted on by sdnd2000

2,510

Hi, I have aggregation function inside the link entity, it is returning total number of records, however, when the link entity has no value, there is no result returned, how can I make it return 0 when there is no value. Please advise,

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

ManoVerse 539 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If i understand correctly you want to collect how many records associated with your table , I am not able to see your fetch xml here but i hope you are using outer join for your link entity, Below is working working fetch xml for me

<fetch aggregate="true">
<entity name="account">

<attribute name="accountid" alias="accountid" groupby="true"/>
<attribute name="name" alias="accountname" groupby="true"/>

<filter type="and">
<condition attribute="statecode" operator="eq" value="0"/>
<condition attribute="createdon" operator="on-or-after" value="2026-01-01"/>
<condition attribute="createdon" operator="on-or-before" value="2026-01-15"/>

</filter>

<link-entity name="contact" from="parentcustomerid" to="accountid" link-type="outer" alias="c">

<attribute name="contactid" alias="contactcount" aggregate="countcolumn"/>

<filter type="and">
<condition attribute="statecode" operator="eq" value="0"/>
</filter>
</link-entity>
</entity>
</fetch>

result would be like this

Was this reply helpful? Yes No