java - SpringData MongoDB 查询嵌套对象和列表对象

Question

我想通过job的code和code的列表找到一个Type文档category，我尝试了以下查询，但没有成功

@Document
public class Type {
    @Id
    private String id;
    @DBRef
    private Job job;
    @DBRef
    private List<Category> categories;
}

public class Job {
    @Id
    private String id;
    private String code;
}

public class Category {
    @Id
    private String id;
    private String code;
}

public interface TypeRepository extends MongoRepository<Type, String> {
    @Query("{ 'job.code': ?0, 'category.code': { $in: ?1 }}")
    Type findByJobAndCategoriesCode(String codeJob, List<String> codeCategories);
}

Answer 1

尝试使用这个

public interface TypeRepository extends MongoRepository<Type, String> {

    Type findOneByJobCodeAndCategoriesCodeIn(String codeJob, List<String> codeCategories);
}