Hi,
We had a requirement where we wanted our resultset to be sorted based on the associated link entity’s attribute.
This is how we need to write our fetch xml query.
Suppose we want to get all the Accounts records and its owner information sorted based on Owner’s Job Title. (Descending)
For this our Fetch XML query be something like this
The result
Bye.
Power Spark By Shrangarika
Exploration of Power Platform
It is my experience timeline.
Sharing my knowledge and experience about the Microsoft Power Platform.
a guide to powering up community
Sponsored by Cloud Formations Ltd
Deriving Solutions and features on Power Platform/Dynamics 365
Thoughts & musings from a Dynamics 365 Ninja!
Learn about Microsoft Dynamics CRM Power Platform customization and implementation and other cool stuffs
I know pre-stroke. I will improve who I was.
Balu Gajjala
Power Melange By Shalinee
Power Automate - Power Apps - SharePoint Online - Azure - Nintex - K2 - Artificial Intelligence
An Inquiry in Being
The Influencers & Influences of Indian Music
Hand's-free money management
A closer look at Microsoft Dynamics 365.
Experienced consultant primarily focused on Microsoft Dynamics 365 and the Power Platform
Specific topics by Django Lohn on the whole Microsoft365 Stack
One Stop Destination for Microsoft Technology Solutions
Naturally Curious
Prasanna Vadlamudi
Power Platform and Dynamics 365
A Microsoft Business Applications MVP
Bass defines your home theater
SQL Server tips and experiences dedicated to my twin daughters.
Discovering Azure DevOps and D365 Business Applications
Lets do IT Spells
Russ Parry REALTOR®
Power Platform & Dynamics CRM
Mail to crmtipsbyprm@gmail.com for queries and suggestions
Giving back to the community what I have learned
Learn and Share
Dynamics CRM Technical & Functional Info
Sometimes you need to look at things from different perspective.
Dynamics 365 Customer Engagement, CRM, Microsoft CRM, Dynamics CRM
Nishant Rana's Weblog 
being a fan of fetchXml myself, this post is worth the info.
LikeLike
How to do group by account type in fetch xml
LikeLike
她得到的修炼功法åªæœ‰ç»ƒæ°”期，练气期巅峰，ç‘基åŽï¼Œå°èŠ±å°±æ— 法在修炼了，看到陈力，自然是想继ç»ä¿®ç‚¼åŽé¢çš„功法。
????? http://h937.cn
LikeLike
è¿™é‡Œå› ä¸ºæ²¡æœ‰é£Žæš´äº†ï¼Œå˜å¾—很ç¹è£ã€‚ä¸å°‘的船在海é¢ä¸Šè¡Œé©¶ã€‚å› ä¸ºæ²¡æœ‰é£Žæš´çš„ç»žæ€ï¼Œæµ·é‡Œçš„妖兽也开始生长，很多人在这里猎æ€å¦–å…½ã€‚å› ä¸ºæ‰å¼€å§‹äº†å年，所以æ¥åˆ°è¿™é‡Œçš„也是ä¸å¾ˆå¤šã€‚
????? http://d677.cn
LikeLike
How to sort on linked entity attribute using QueryExpression?
LikeLike
How did you solve the problem? I have the exact same question mate.
LikeLike
LinkEntity has Orders Property.
liInstance.Orders.Add(new OrderExpression(“name”,OrderType.Ascending));
LikeLiked by 1 person
this doesn’t work
LikeLike
because the order on linked entity is applyed on linkend entity only (make sense on outer join returning more records)
LikeLike