title: Ordering record based on list field in apache ignite Sql Queries
body: <p>Lets say I have an object Employee below and it is stored in ignite cache.</p>
  
  <pre><code>   Employee{
      int id;
      String name;
      List&lt;Double&gt; marksInorder;//marks for each subject in order
      //hypothetical situation, actual requirement is different
    }
  </code></pre>
  
  <p>I am using SQLQuery to fetch records from ignite cache and need to fetch top N records with maximum of marksInorder. But ignite does not support orderBy on list fields.</p>
  
  <p><a href="http://apache-ignite-users.70518.x6.nabble.com/Ignite-SQL-Queries-on-Lists-fields-sorting-td14129.html#a14305" rel="nofollow noreferrer">http://apache-ignite-users.70518.x6.nabble.com/Ignite-SQL-Queries-on-Lists-fields-sorting-td14129.html#a14305</a></p>
  
  <p>Is there a workaround for this.</p>