Spring boot & mongo custom query with order by

Question

I have a custom query in org.springframework.data.mongodb.repository that goes

@Query("{'additionalInfo.suspicious' : true}")
List<Trip> findSuspiciousTripsByFleetId(String fleetId, Pageable pageable);

How could I add a order by (date desc) to this?

Does it magically accept OrderByDateDesc suffix for example?

thanks in advance.

Answer 1

You can do this by adding a Sort attribute to the method. And pass the sort argument when calling the method.

@Query("{'additionalInfo.suspicious' : true}")
List<Trip> findSuspiciousTripsByFleetId(String fleetId, Sort sort);

And during invocation of this method, do

Sort sort = new Sort(Sort.Direction.DESC, "date")
tripRepository.findSuspiciousTripsByFleetId("fleedtId", sort);  

spring-data will take care of the rest for you.