Spring data mongodb query for subdocument field

Question

I'm using Spring Data's CrudRepository with mongodb and i have some issue to write a query which will select a document with specific subdocument value. Here's an example:

{
"_id" :,
"_class" :,
"matchHeader" : {
    "suspend" : {},
    "active" : true,
    "booked" : true,
    "eventId" : NumberLong(1009314492),
    "status" : ""
},
"matchInfo" : {

    }
}

}

i need to select the document with specific eventId field in matchHeader subdocument. i tried to write a function like this findByMatchHeaderEventId(id) but it doesn't helped at all.how can i achieve that?

Marc Tarin · Accepted Answer · 2016-02-03 14:40:33Z

5

Property traversal for nested properties is explained in The Spring Data MongoDB Reference Documentation.

You need to properly define your domain object class (constructor/getters/setters omitted):

public class MyDocument {
  @Id
  private String id;
  private MatchHeader matchHeader;
  private MatchInfo matchInfo;
  ...
}

public class MatchHeader {
  private Map<,> suspend;
  private boolean active;
  private boolean booked;
  private Long eventId;
  private String status;
}

and your repository class

public interface MyDocumentController extends MongoRepository<MyDocument, String> {
  public List<MyDocument> findByMatchHeaderEventId(Long id);
}

Otherwise you can try the findByMatchHeader_EventId suggested in another answer.

answered Feb 3, 2016 at 14:40

Marc Tarin

3,17919 silver badges52 bronze badges

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

Comments

Gaurav Goel · Accepted Answer · 2015-10-02 09:36:27Z

4

Try

findByMatchHeader_EventId

instead of

findByMatchHeaderEventId

answered Oct 2, 2015 at 9:36

Gaurav Goel

3252 silver badges14 bronze badges

Comments

suthar_arun · Accepted Answer · 2021-04-29 04:37:17Z

0

You can use org.springframework.data.mongodb.core.query.Query for preparing a custom query for fetching documents with specific subdocument Key value.

In your case, you can code like:

Query query = new Query();
query.addCriteria(Criteria.where("matchHeader.eventId").is(id));

Note: But for Query you will be required to use MongoTemplate.

answered Apr 29, 2021 at 4:37

suthar_arun

1192 silver badges5 bronze badges

Collectives™ on Stack Overflow

Spring data mongodb query for subdocument field

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related