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.
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