Dynamics Community Forum Thread Details

I have below fetchxml query that is running fine Advanced Find / FetchXML Builder. However, in liquid templates, same query is not returning anything.

{% fetchxml abc_vat_query %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="new_vatgroup">
<attribute name="new_vatgroupid" />
<attribute name="new_name" />
<attribute name="createdon" />
<order attribute="new_name" descending="false" />
<link-entity name="msdyn_organizationalunit" from="msdyn_organizationalunitid" to="new_organisationalunit" link-type="inner" alias="as">
<link-entity name="contact" from="new_resourcingunit" to="msdyn_organizationalunitid" link-type="inner" alias="at">
<filter type="and">
<condition attribute="contactid" operator="eq" value="{{user.id}}" />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>
{% endfetchxml %}{
"totalcount": "{{ abc_vat_query.results.total_record_count }}"
}

No record found.