Hi,
I am facing a strange problem with CRM Portal. I have a fetchxml query which when run in Fetchxml Tester gives me 5 records. But when I use it in CRM Portals in Liquid.
It does not give me any results.
Query is below which gives me 5 records in Fetch testing tool but does not give any record when used in Portals
{% fetchxml my_query %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="new_invoice">
<attribute name="new_totalamountdue" />
<attribute name="new_invoicenumber" />
<attribute name="new_invoicedate" />
<order attribute="new_vendor" descending="false" />
<filter type="and">
<condition attribute="new_invoicedate" operator="last-month" />
<condition attribute="statecode" operator="eq" value="0" />
</filter>
</entity>
</fetch>
{% endfetchxml %}
In portals when I check the result size/count below give me "0":-
{{ my_query.results.entities.size }}
If someone has an idea of what is wrong, please help me.
(If I relax the filters in fetchxml query e.g. remove conditions, then it works @CRM portal shows records)
*This post is locked for comments
I have the same question (0)
