Share
ReportHi, I am trying to create a report based on 2 entities. Some information as the total amount for the quote is in quote entity but the product details is in quote detail entity. I used the advanced find and started from quote detail and then brought some columns from quote. Nevertheless when I try to create my report I keep getting this error: "The attribute "productname" cannot be found for entity "quotedetail". Specify a valid query, and try again"
this is my fetch :
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="quotedetail">
<attribute name="productid" />
<attribute name="productdescription" />
<attribute name="priceperunit" />
<attribute name="quantity" />
<attribute name="extendedamount" />
<attribute name="quotedetailid" />
<attribute name="description" />
<attribute name="productname" />
<attribute name="quoteid" />
<attribute name="overriddencreatedon" />
<attribute name="salesrepid" />
<attribute name="baseamount" />
<attribute name="uomid" />
<order attribute="productid" descending="false" />
<link-entity name="quote" from="quoteid" to="quoteid" visible="false" link-type="outer" alias="a_5a6d1bb07139e811a833000d3a342e90">
<attribute name="totalamount" />
<attribute name="shipto_composite" />
<attribute name="revisionnumber" />
<attribute name="overriddencreatedon" />
<attribute name="quotenumber" />
<attribute name="ownerid" />
<attribute name="name" />
<attribute name="randgrp_engineeringsupportmanager" />
<attribute name="effectiveto" />
<attribute name="effectivefrom" />
<attribute name="createdon" />
</link-entity>
</entity>
</fetch>
*This post is locked for comments
All responses (
Answers (
30,188
