Spring Data MongoDB AND/OR query with multiple optional parameters

Question

I'm trying to execute a query with more than 2 optional parameters but I don't get any result. For the 2 parameters I followed the answer of this question spring-data-mongo - optional query parameters?.

So for example, with the following query everything is ok:

@Query("{$and: [{$or : [ { $where: '?0 == null' } , { a : ?0 } ]}, {$or : [ { $where: '?1 == null' } , { b : ?1 }]}]}")

But if I add one more parameter it stops to work:

@Query("{ $and : [{$and: [{$or : [ { $where: '?0 == null' } , { a : ?0 } ]}, {$or : [ { $where: '?1 == null' } , { b : ?1 }]}]},{$or : [ { $where: '?2 == null' } , { c : ?2 }]}]}")

I triple checked the syntax and seems ok, but I get empty results (even if I'm sure I should obtain at least few documents).

Any idea?

Konstantin Yovkov · Accepted Answer · 2015-04-21 12:26:05Z

8

If you try carefully hand-format you query to be more readable, you will note that you have made a few mistakes with the closing brackets.

Try this query instead:

{ $and : 
    [{
       $and: 
        [
         {$or : [ { $where: '?0 == null' } , { a : ?0 }]}, 
         {$or : [ { $where: '?1 == null' } , { b : ?1 }]},
         {$or : [ { $where: '?2 == null' } , { c : ?2 }]}
        ]
    }]
}

Side note: I think one $and will be enough, i.e. remove the top-level $and operator.

edited Apr 21, 2015 at 12:26

answered Jul 30, 2014 at 22:03

Konstantin Yovkov

63k9 gold badges107 silver badges152 bronze badges

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

2 Comments

Alexio Cassani Over a year ago

Thk! I didn't know $and operator could work with more than 2 elements. It works and it is more readable too :-)

Sercan Ozdemir Over a year ago

Is there a way to use $regex here ? Because I couldn't make it work

Collectives™ on Stack Overflow

Spring Data MongoDB AND/OR query with multiple optional parameters

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related