title: FetchXML ordering results and pagination based on linked entity's attributes
body: <p>I am writing a FetchXML query to retrieve a list of persons to be displayed in a table. This table should be able to provide search, pagination and sorting on all columns. The problem here is that the person entity has the father as a link-entity, and the father's "firstName" is already a column in the table that I am currently building. I need a query that gives me the ability to retrieve the results sorted by the father's "firstName", filtering the results based on the same attribute and applying pagination (skip and take) not having to get all the rows and applying filtering afterwards.
  What I tried so far is every possible thing derived from the method mentioned in this post: 
  <a href="https://nishantrana.me/2012/04/27/sorting-on-link-entitys-attribute-in-fetch-xml-crm-2011/" rel="nofollow noreferrer">https://nishantrana.me/2012/04/27/sorting-on-link-entitys-attribute-in-fetch-xml-crm-2011/</a></p>
  
  <p>Unfortunately, not working. Any suggestions?</p>