title: Slick 3.0.0 - How to sortBy on a query with joinLeft
body: <p>This question is related to <a href="https://stackoverflow.com/questions/24190955/slick-dynamic-sortby-in-a-query-with-left-join/24191448#24191448?newreg=fc94bcd17d3f410bb5f563d3c4a7eede">another</a>. I'm also trying to sort on a query with a joinLeft but in slick 3.0.0. And as the Option Rep are automatically lifted how would I do the exact same thing ?:</p>
  
  <pre><code>def list(filter: String, orderBy: Int):Future[Seq[(Computer, Option[Company])]] = {
      val initialQuery = for {
          (computer, company) &lt;- Computer.filter(_.name like filter) leftJoin 
              Company on (_.companyId === _.id)
      } yield (computer, company)
  
      val sortedQuery = orderBy match {
          case 2 =&gt; initialQuery.sortBy(_._1.name) //Works ok, column from a primary table
          case 3 =&gt; initialQuery.sortBy(_._2.map(_.name)) //could not find implicit value for parameter ol: slick.lifted.OptionLift[slick.lifted.ColumnOrdered[String],slick.lifted.Rep[Option[QO]]]
      }
      db.run(sortedQuery.result)
  }
  </code></pre>
  
  <p>Thanks,</p>