Something wrong with mongo (1.4.4) request

Question

When I query like this :

collection.find({ "position": { $in: [ 1, 2 ] } }).toArray()....

I get the right result, when I use $and or $or , for example:

collection.find({ $or: [ { "position": 1 }, { "position": 2 }  ] }).toArray()...

I always get the empty result

EDIT: when trying to query in console I get:

> db.foo.find({"position":{$in:[1,2]}})
{ "name" : "Jon Doe", "position" : 1, "arrival" : "8:00", "_id" :ObjectId("512e2ed286d19b9e4d000001") }
{ "name" : "Jack Smith", "position" : 2, "arrival" : "10:00", "_id" : ObjectId("512e2ed286d19b9e4d000007") }

db.foo.find( { $or : [{"position":1},{"position":2}]} )

  //nothing here

From this, I get the impression, my code is OK and the problem is elsewhere...

You have one too many closing "}" after ""position": 2" in the second option, should be `collection.find({ $or: [ { "position": 1 }, { "position": 2 } ] }).toArray()` — darma, Mar 01 '13 at 15:47
ok, this was just a mistake while copying to Stack, in fact your proposal does that error — slezadav, Mar 01 '13 at 15:56
That's really old. `$or` was added in 1.6 so there's your problem. — JohnnyHK, Mar 01 '13 at 16:16
maybe you can add the version to the question so when people come across it in the future they will know it won't apply to them. — Asya Kamsky, Mar 01 '13 at 20:55

score 2 · Answer 1 · answered Mar 01 '13 at 15:54

Query Something like this,

> db.foo.find({"x":{$in:[1,2]}})
{ "_id" : ObjectId("513046c8ec1e5e38449f1789"), "x" : 1, "y" : 2 }
{ "_id" : ObjectId("5130cdfdf8378ccc2005bcf2"), "x" : 2 }
> 

> db.foo.find( { $or : [{"x":1},{"x":2}]} )
{ "_id" : ObjectId("513046c8ec1e5e38449f1789"), "x" : 1, "y" : 2 }
{ "_id" : ObjectId("5130cdfdf8378ccc2005bcf2"), "x" : 2 }
>

score 2 · Accepted Answer · answered Mar 01 '13 at 16:17

2

You need to use newer version of Mongo. It is supported for version > 1.6.

See the changelog.

answered Mar 01 '13 at 16:17

Michal

15,429
10
73
104

Something wrong with mongo (1.4.4) request

2 Answers2