Query document with embedded document field using spring data repository

Question

I am new to Spring-data, so pardon me if my question is to naive

I am trying to query the document which looks like this:

     {
       _id: 1,
       name: "sue",
       age: 19,
       type: 1,
       status: "P",
       favorites: { artist: "Picasso", food: "pizza" },
       finished: [ 17, 3 ],
       badges: [ "blue", "black" ],
       points: [
          { points: 85, bonus: 20 },
          { points: 85, bonus: 10 }
       ]
     }

I wanted to do the query which gives me the list of the entries which contains the favourites.artist="Picasso".

I know how to do this using the MongoTemplate I wanted to do that using MongoRepository.

I was reading some document which shows query like this

findByFavorites(Favorites favorites)

but I couldn't find anything with which I can query using the field of the embedded document.

Konrad Lötzsch · Accepted Answer · 2016-06-11 20:16:44Z

1

It should be

    findByFavoritesArtist(@Param("favorites.artist") String artist);

So you just concatenate together the names of the properties in the property path in our embedded object. It is possible that the above query is redundant and you can leave out the @Param annotation.

answered Jun 11, 2016 at 20:16

Konrad Lötzsch

4787 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Query document with embedded document field using spring data repository

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