Spring data mongo use OR in Query

Question

Let´s see if somebody can help with this.

I want use Repository of Spring Data mongodb, and I want use Query annotation to filter the find by value A=10 or A=20

  @Query("{A: 10, A:20}")   findById(int id); 

Obiously "," try to make an AND, and I need an OR.

Any idea please?

Answer 1

Or if you are using a Criteria API

Criteria criteria = new Criteria(); criteria.orOperator(Criteria.where("A").is(10),Criteria.where("B").is(20)); Query query = new Query(criteria);  mongoOps.find(query, <Yourclass>.class, "collectionName"); 

Answer 2

I think this might work

@Query("{'$or':[ {'A':10}, {'B':20} ] }")