Adding Support For Sorting in @Query Annotation and Creating an alias for value [DATAMONGO-1979]

[spring-projects-issues]

Ankur Pathak opened DATAMONGO-1979 and commented

We support sorting in Repository methods like this:

interface IScanRepository extends MongoRepository<Scan, String> {
  Page<UserScan> findByOrderByCreatedDesc(Pageable pageable);
}

But we don't support sorting in repository methods annotated with @Query:

interface IScanRepository extends MongoRepository<Scan, String> {

  @Query("{}")
  Page<UserScan> findByOrderByCreatedDesc(Pageable pageable);
}

as @Query annotation don't have any parameter to specify sort. Ideally it should have option to specify sort and also an alias to value parameter to specify filter, something like below:

interface IScanRepository extends MongoRepository<Scan, String> {

  @Query(value/filter = "{}", sort = "\{ created : -1 }")
  Page<UserScan> findByOrderByCreatedDesc(Pageable pageable);
}

So this will make uniform support for sorting in both type of repository methods.

 

 

 

 

 

---

Referenced from: pull request #566

[spring-projects-issues]

Oliver Drotbohm commented

You can either equip the Pageable with a Sort instance or directly use Sort instead of Pageable if only sorting is needed

[spring-projects-issues]

Ankur Pathak commented

Ya right that are options we can use at run time. But doesn't allow us to write our queries at compile time with sorting option at one place. And this also

make difficult when using sorting with spring data rest. So ideally we should support it, so we can support query with filter, projection and sorting at one place. I would like to take it one step forward that we should also add support for named queries so that we can write query in separate file with filter,

projection and sorting at one place(the way we do in jpa and solr)