query array of embedded documents in spring data mongodb

Question

I have simple question:

How do I express this query

db.inventory.find( { "instock": { warehouse: "A", qty: 5 } } )

Query for a Document Nested in an Array

in spring data mongoDB, preferably using QueryDSL but other ways are welcome, too.

All my queries so far match fields on any embedded document in the array but I need to match both on the same.

charlycou · Accepted Answer · 2019-02-18 22:22:02Z

8

Using Spring Data repository, you could use :

1 - @Query annotation

@Query("{ 'instock': { 'warehouse': ?0, 'qty': ?1 } }")
List<YourClass> findByInstock(String warehouse, int qty);

2 - Custom repository method implementation

List<YourClass> findByInstock(String warehouse, int qty) {
  return mongoTemplate.find(Query.query(Criteria.where("instock").elemMatch(Criteria.where("warehouse").is(warehouse).and("qty").is(qty)));

You can find more material here on how to implement this method. }

answered Feb 18, 2019 at 22:22

charlycou

2,05519 silver badges41 bronze badges

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

2 Comments

charlycou Over a year ago

@user3813234 , did you manage to setup the query or do you need more material?

user3813234 Over a year ago

Hi, I used your second apprach with the elemMatch. Worked perfectly! Thanks!

Collectives™ on Stack Overflow

query array of embedded documents in spring data mongodb

1 Answer 1

1 - @Query annotation

2 - Custom repository method implementation

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 - @Query annotation

2 - Custom repository method implementation

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related