Springboot with Mongodb Criteria.orOperation doesn't work

Question

I am trying to create one OR operation with Criteria in MongoDB with Spring-Boot, this is my code:

TypedAggregation<Ficha> agg = newAggregation(Ficha.class,    
   // match(Criteria.where("parte.nome").regex(".*"+ query+".*")),
   // match(Criteria.where("parte.nome").regex(".*"+ query+".*").orOperator(Criteria.where("parte.documentos.numero").regex(".*"+ query+".*"))),
   // match(Criteria.where("parte.documentos.numero").regex(".*"+query+".*")),
   group("parte.nome").first("parte.nome").as("nome"),
   project().and("nome").previousOperation().and("nome").as("nome")

If I uncomment line 1, it works (search only in parte.nome).

If I uncomment the last line, it works too (but searches only in parte.documentos.numero).

If I uncomment the middle line, it doesn`t work. How do I solve this?

chridam · Accepted Answer · 2016-10-05 19:00:01Z

1

Implement it as:

TypedAggregation<Ficha> agg = newAggregation(Ficha.class,    
   match(new Criteria().orOperator(
        Criteria.where("parte.nome").regex(".*"+ query+".*"),
        Criteria.where("parte.documentos.numero").regex(".*"+ query+".*")
    )),  
   group("parte.nome").first("parte.nome").as("nome"),
   project().and("nome").previousOperation().and("nome").as("nome")
);

answered Oct 5, 2016 at 19:00

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Collectives™ on Stack Overflow

Springboot with Mongodb Criteria.orOperation doesn't work

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