title: Sorting on the property of a nested collection in OData
body: <p>We have the object model similar to the one below,</p>
  
  <pre><code>context.People
    .include('Children')
    .include('Children.FavoriteColor')
    .order('Name')
    .order('Children.Name')
    .order('Children.FavoriteColor.Brightness')
  </code></pre>
  
  <p>There is an OData Query that needs to filter by Brightness. </p>
  
  <p>We tried with the following </p>
  
  <p><code>$expand=Children&amp;$orderby=Children/FavoriteColor/Brightness</code> 
  but it gives error because the FavoriteColor is a collection. However, there is also the Primary Keys added by default in the generated SQL from EF before any of the orderby columns. </p>
  
  <p>Kindly suggest how the filtering can be done based on the Brightness [Child collection property using OData]</p>
  
  <p>This issue is similar to this <a href="https://github.com/jaystack/jaydata/issues/62" rel="nofollow noreferrer">query</a> </p>