If you want to sort the results based from linked data, we can add order by link entity’s attribute like this :
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"> <entity name="contact"> <attribute name="fullname" /> <attribute name="telephone1" /> <attribute name="contactid" /> <link-entity name="contactquotes" from="contactid" to="contactid" visible="false" intersect="true"> <link-entity name="quote" from="quoteid" to="quoteid" alias="aa"> <order attribute="createdon" descending="false" /> </link-entity> </link-entity> </entity> </fetch> |