When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size
Issue:
When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size
Solution:
It is possible that a sort included in the fetchXML has caused this behavior to occur. In the example below you can see sort/order by (<order attribute="rc_name" descending="true" />).Removing this sort may resolve the issue.
<fetch xmlns:generator="Mmmtl.SQL4CDS"><entity name="rc_location"><attribute name="rc_name" alias="UnitNumber" /><attribute name="rc_locationid" /><attribute name="rc_propertyactualopendate" alias="PropertyActualOpenDate" /><attribute name="rc_propertyclosedate" alias="PropertyCloseDate" /><attribute name="statuscode" /><attribute name="ext_tempclosed" /><attribute name="ext_reopen" /><attribute name="ext_uta" alias="UTA" /><attribute name="ext_licenseagreementexpiration" alias="LicenseAgreementExpiration" /><attribute name="ext_licensetype" alias="LicenseType" /><attribute name="ext_cooprate" /><attribute name="ext_divisionlkp" /><attribute name="frm_brandid" /><attribute name="rc_dmaid" /><filter><condition attribute="statecode" operator="eq" value="0" /></filter><order attribute="rc_name" descending="true" /></entity></fetch>
Book a Presales Call
Related Articles
When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size
Issue: When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size Solution: It is possible that a sort included in the fetchXML has caused this behavior to occur. In the example below ...When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size
Issue: When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size Solution: It is possible that a sort included in the fetchXML has caused this behavior to occur. In the example below ...When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size
Issue: When setting sort/order in FetchXML on Dynamics CRM Source, the component returns only the number of rows set in batch size Solution: It is possible that a sort included in the fetchXML has caused this behavior to occur. In the example below ...Dynamics CRM Source: How to modify the FetchXML statement dynamically at runtime
The FetchXML statement is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired FetchXML statement. (Example: vFetchXMLModifiedOnDate) Right-click on the data ...Where can I find the documentation for the Dynamics CRM Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Dynamics CRM Source can be found at the following link. For many of the components you can find ...