如何在mongodb存储库中使用@query添加订单 [英] How to add orderby using @query in mongodb repository

问题描述

我想用Spring将orderby添加到mongodb中的以下存储库方法中.我尝试了各种方法，但是没有用

I want to add orderby to the following repository method in mongodb with spring. I tried in various methods, but didnt work

public interface StageRepository extends MongoRepository<Stage, String> {

     @Query("{$and: [ { 'categoryId': { $eq: ?0 } }, { 'isDeleted': { $eq: ?1 } } ]}")
     public List<Stage> findByCategoryIdAndIsNotDeleted(String categoryId, Boolean deleted);

}

我想在查询中按订单"添加订单.

I want to add orderby 'order' in the query.

不确定如何做到.

推荐答案

您可以这样做:

@Query("{$and: [ { 'categoryId': { $eq: ?0 } }, { 'isDeleted': { $eq: ?1 } } ]}")
public List<Stage> findByCategoryIdAndIsNotDeleted(String categoryId, Boolean deleted,org.springframework.data.domain.Sort sort);

然后，当您调用此方法时，创建如下的Sort对象:

And When you call this method ,create Sort object like below:

Sort sort = new Sort(Direction.ASC/DESC,"order");

这篇关于如何在mongodb存储库中使用@query添加订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！