locked
2000 Char limit of FetxchXML RRS feed

  • Question

  • 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>

    Friday, April 22, 2016 1:33 PM