MongoDB/Spring and @Query

[Sergio Rubio Lafuente]

I'm working with Spring Boot and MondoDB. My project is growing up, and I'm trying to make complex queries. Working with 'MongoRepository' I tryed to make the following query:

@Query("{$match:{'_id':?0}},{$unwind:'$menuOptions'},{$match:{'menuOptions.active':'true'}},{$unwind:'$menuOptions.menuSubOptions'},{$match:{'menuOptions.menuSubOptions.active':'true'}}")
    Roles findMenu(String name);

With the following result:

Caused by: com.mongodb.MongoException: Can't canonicalize query: BadValue unknown top level operator: $match

I've been trying to make another queries (for instance, a $sort/$orderby with the '@Query' annotation with the same result. Any idea?

[Ross Lawley]

$match is an unknown query operator but is an aggregation pipeline operator, so it looks from the error you are trying to do a find() operation rather than an aggregate() operation.

Ross

[Sergio Rubio Lafuente]

Thanks! I will try it ! Thing is, why is not working with $orderBy or sort? Find +sort/orderBy should be working, isn't it?

In the other hand, I was trying to find more info about queries + mongoRepository and is hard to find complex compositions, where can i get more info? (Especially MongoRepository+Aggregation)

Thanks a lot!