Dynamics Community Forum Thread Details

Hi,

I am trying to modify the existing Order report. Like the Order report I want to have it display the order that is currently being displayed on the form. Right now the report does not display any order. It was my understanding that the filtered views were content based but I don't seem to be retrieving any data.

Here is the fetchxml that I'm currently using...

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="salesorder"  enableprefiltering="true" prefilterparametername="FilteredSalesOrder">
    <attribute name="name" />
    <attribute name="totalamount" />
    <attribute name="statuscode" />
    <attribute name="customerid" />
    <attribute name="customeridtype" />
    <attribute name="createdon" />
    <attribute name="salesorderid" />
    <attribute name="totaltax" />
    <attribute name="totallineitemdiscountamount" />
    <attribute name="totallineitemamount" />
    <attribute name="totaldiscountamount" />
    <attribute name="totalamountlessfreight" />
    <attribute name="shipto_telephone" />
    <attribute name="shipto_stateorprovince" />
    <attribute name="shipto_postalcode" />
    <attribute name="shipto_name" />
    <attribute name="shipto_line3" />
    <attribute name="shipto_line2" />
    <attribute name="shipto_line1" />
    <attribute name="shipto_freighttermscode" />
    <attribute name="shipto_fax" />
    <attribute name="shipto_country" />
    <attribute name="shipto_city" />
    <attribute name="freightamount" />
    <attribute name="discountpercentage" />
    <attribute name="discountamount" />
    <attribute name="shippingmethodcode" />
    <attribute name="requestdeliveryby" />
    <attribute name="paymenttermscode" />
    <attribute name="ordernumber" />
    <attribute name="billto_stateorprovince" />
    <attribute name="billto_postalcode" />
    <attribute name="billto_name" />
    <attribute name="billto_line3" />
    <attribute name="billto_line2" />
    <attribute name="billto_line1" />
    <attribute name="billto_city" />
    <order attribute="name" descending="false" />
<filter type="and">
      <condition attribute="ordernumber" operator="eq" value="FilteredSalesOrder.salesorderid" />
    </filter>
    <link-entity name="contact" from="contactid" to="customerid" visible="false" link-type="outer" alias="salesorder_contact">
      <attribute name="emailaddress1" />
      <attribute name="fullname" />
      <attribute name="address1_postalcode" />
      <attribute name="address1_line3" />
      <attribute name="address1_line2" />
      <attribute name="address1_line1" />
      <attribute name="address1_stateorprovince" />
      <attribute name="address1_city" />
    </link-entity>
    <link-entity name="account" from="accountid" to="customerid" visible="false" link-type="outer" alias="salesorder_account">
      <attribute name="name" />
      <attribute name="address1_stateorprovince" />
      <attribute name="address1_postalcode" />
      <attribute name="address1_line3" />
      <attribute name="address1_line2" />
      <attribute name="address1_line1" />
      <attribute name="address1_city" />
    </link-entity>
    <link-entity name="systemuser" from="systemuserid" to="owninguser" visible="false" link-type="outer" alias="salesorder_systemuser">
      <attribute name="preferredphonecode" />
      <attribute name="personalemailaddress" />
      <attribute name="mobilephone" />
      <attribute name="homephone" />
      <attribute name="fullname" />
      <attribute name="address1_telephone2" />
      <attribute name="address1_telephone1" />
      <attribute name="address1_postalcode" />
      <attribute name="address1_line3" />
      <attribute name="address1_line2" />
      <attribute name="address1_line1" />
      <attribute name="address1_stateorprovince" />
      <attribute name="address1_city" />
    </link-entity>
  </entity>
</fetch>

Thank you for the help!!

Gary