Hi All,
I have the following code in my web template. Dategrouping is supposed to return month number(1 to 12) based on the cra3c_gcpayoutmonth column in the below case. Even though i have records for the current month i.e September, its returning 9 and sometimes 8. Not sure what is going wrong. We are nearing Go-Live and this issue is creating lot of tension. Need your help with the same.
{% for entity in contact_query.results.entities %}
{% fetchxml PurchaseSummaryQuerys %}
<fetch distinct="false" mapping="logical" aggregate="true" output-format="xml-platform" version="1.0">
<entity name="cra3c_purchasehistory">
<attribute name="cra3c_gcpayoutmonth" alias="year" groupby="true" dategrouping="year" />
<attribute name="cra3c_gcpayoutmonth" alias="month" groupby="true" dategrouping="month" />
<attribute name="cra3c_lbspurchased" alias="value" aggregate="sum" />
<order alias="year" />
<order alias="month" />
<filter type="and">
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="cra3c_customernumber" operator="eq" value="{{entity.cra3c_customernumber}}" />
</filter>
</entity>
</fetch>
{% endfetchxml %}
{% endfor %}
Thanks in advance
