dao.scala

  def findPaged(limit: Int, offset: Int)(
      implicit filter: Option[IssueSortAndFilterOptions] = None)
    : Future[Page[Issue]] = {
    db.run(
      (for {
        data <- filteredQuery(filter)
        .sortBy { a =>
          filter.flatMap(_.term) match {
            case Some(search) => a.title <<-> search
            case None => ???
          }
        }
          .drop(offset)
          .take(limit)
          .result
        total <- filteredQuery.length.result
      } yield
        (Page(totalEntities = total,
              data = data,
              currentPage = offset / limit,
              pageSize = limit))))
  }