How to do this query in mongoDB

Question

The query logic is like that:

(A > x OR A < y) AND (B > m OR B < n) AND C = z db.test.find({$or:[{A:{$gt:x}}, {A:{$lt:y}}], C:z})

but how to add B's condition into this query.

planestepper · Accepted Answer · 2014-08-29 01:34:13Z

1

Being (A > x OR A < y) A and (B > m OR B < n) B, then the rest C, wrap them inside an $and comparison: {$and: [A, B, C]}, such as:

db.test.find({ $and: [ {$or: [{A: {$gt: x}}, {A: {$lt: y}}]}, {$or: [{B: {$gt: m}}, {B: {$lt: n}}]}, C: z ] })

answered Aug 29, 2014 at 1:34

planestepper

3,32729 silver badges40 bronze badges

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

2 Comments

helloxk Over a year ago

But my MongoDB server version is 1.8.2, don't support $and operator

Danish Over a year ago

if $and operator is not supported, do it at application level. This is the way out. You may have to get data in two or three queries and then 'AND' them on app level.

Wizard · Accepted Answer · 2014-08-29 09:54:33Z

As you can use $or but can't use $and, you can split the first query group (totally 3 groups) like this:

db.test.find({ $or : [ { A : { $gt : x }, $or : [ { B : { $gt : m } }, { B : { $lt : n } } ] }, { A : { $lt : y }, $or : [ { B : { $gt : m } }, { B : { $lt : n } } ] } ], C : z });

Collectives™ on Stack Overflow

How to do this query in mongoDB

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related