SpringData MongoDB Query on nested object and list object

Question

I want to find a Type document by the code of job and by the list of code of category, i tried the below query but it didn't work

@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);
}

Ashish Bakwad · Accepted Answer · 2019-12-24 17:15:20Z

1

try using this one

public interface TypeRepository extends MongoRepository<Type, String> {

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

answered Dec 24, 2019 at 17:15

Ashish Bakwad

8115 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SpringData MongoDB Query on nested object and list object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related