Hi
I am trying to get all emails in our CRM instance to warehouse it, and trying to load it year by year.
My query is:
<fetch mapping="logical">
<entity name="email" enableprefiltering="1">
<attribute name="activityid"/>
...
<link-entity name="systemuser" to="owninguser">
<filter type="and">
<condition attribute="createdon" operator="ge" value="2019-01-01" />
<filter type="and">
<condition attribute="createdon" operator="le" value="2019-12-31" />
</filter>
</filter>
</link-entity>
</entity>
</fetch>
but I have also tried the following filters
1)
<filter type="and">
<condition attribute="createdon" operator="ge" value="2019-01-01" />
<condition attribute="createdon" operator="le" value="2019-12-31" />
</filter>
2)
<filter type="and">
<condition attribute="createdon" operator="in-fiscal-year" value="2019" />
</filter>
3)
<filter type="and">
<condition attribute="createdon" operator="on-or-after" value="2019-01-01" />
<condition attribute="createdon" operator="on-or-before" value="2019-12-31" />
</filter>
but none of them return only emails created in 2019. They DO return - consistently - the same number of rows, with these properties:
What am I missing? I am at my wits end.
Thanks!
