locked
Custom order report is not displaying any data RRS feed

  • Question

  • 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 the content based but I don't seem to be retrieving any data.

    Thanks for the help, Gary

    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>


    • Edited by GaryMk Monday, July 28, 2014 5:06 PM
    Monday, July 28, 2014 5:06 PM