how to query array with specific condition in MongoDB

Question

here's my mongodb object example

{
    "_id": ObjectId("asdklfjasdlkfjal"),
    "geometry": {
        "type": "Point",
        "coordinates": [
            -26.62375,
            152.86114
        ]
    }
},
{
    "_id": ObjectId("asdklfjasdlkfjal2"),
    "geometry": {
        "type": "Point",
        "coordinates": [
            -28.62375,
            123.86114
        ]
    }
}

I have read the document here but it does not show me an option to query only the first element of the array.

I've tried the following line on MongoHub but it gives me "invalid operator: $and" msg

{"geometry.coordinates": {$and: [{$lt: -30, $gt: 151}, {$lt: -35, $gt: 151}]}}

For example, I'd like to query the elements that have the value greater than -27 as the first value of the array. So only the first example object should be pulled no matter what value the second element has in the array (or the other way around).

Also found the same question here but it was 3yrs ago so thought there should be a better way by now.

Thanks for reading my question.

Neil Lunn · Accepted Answer · 2014-06-25 08:59:30Z

2

Not really the same as the question you referenced. Your "coordinates" are fixed to two positions, longitude and latitude. All you really need is "dot notation":

 db.collection.find({ "geometry.coordinates.0": { "$gt": -27 } })

So the 0 stands for the fist position (longitude) and you would use 1 for the second position (latitude).

answered Jun 25, 2014 at 8:59

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

1 Comment

Eugene Yu Over a year ago

Dang! it was the dot notation!! I first tried [0] then gave up haha. Thanks for your answer.

Collectives™ on Stack Overflow

how to query array with specific condition in MongoDB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related