Hi Everybody,
I have a problem with CRMFetchXML reporting with CRM Online. I designed a report which queries the data just with fetch. I need to get the image of the note from annotation table. When i run the fetch just below , documentbody column returns the first 2000
char of the byte array. I'm stuck with this problem.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="quotedetail">
<attribute name="productid" />
<attribute name="uomid" />
<attribute name="par_resim" />
<attribute name="productdescription" />
<attribute name="priceperunit" />
<attribute name="quantity" />
<attribute name="extendedamount" />
<attribute name="quotedetailid" />
<order attribute="productid" descending="false" />
<filter type="and">
<condition attribute="par_uruntipi" operator="eq" value="2" />
</filter>
<link-entity name="quote" from="quoteid" to="quoteid" alias="aa">
<filter type="and">
<condition attribute="par_resim1" operator="null" />
<condition attribute="quoteid" operator="eq" uiname="ElKOMIX-120 Quick Master" uitype="quote" value="@id" />
</filter>
<attribute name="name" />
<attribute name="totallineitemamount" />
<attribute name="totalamountlessfreight" />
<attribute name="freightamount" />
<attribute name="totalamount" />
</link-entity>
<link-entity name="transactioncurrency" from="transactioncurrencyid" to="transactioncurrencyid" alias="ab">
<attribute name="currencysymbol" />
</link-entity>
<link-entity name="product" from="productid" to="productid" alias="bm" link-type="outer">
<link-entity name="annotation" from="objectid" to="productid" alias="bn" link-type="outer">
<attribute name="documentbody" />
<attribute name="mimetype" />
<filter type="and">
<condition attribute="subject" operator="eq" value="1" />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>
