Mongodb query based on item at specific position in array

Question

I want to run a query where an item at a specific position in an array needs to be compared.

For example, consider the GeoJSON format for storing location data.

//sample document from collection user
{
    name: "Some name",
    location : {
        type: "Point",
        coordinates : [<Longitude>, <Latitude>]
    }
}

How would I query users located at a specific longitude?

I cant seem to find anything in the documentation which can help me do the same.

Queries I have tried:

db.users.find({"location.coordinates[0]" : -73.04303})

Sede · Accepted Answer · 2015-02-09 14:02:18Z

8

Change your query to the following

   db.users.find({"location.coordinates.0" : -73.04303})

answered Feb 9, 2015 at 14:02

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

1 Comment

Mostafiz Rahman Over a year ago

What id the index is a variable, not 0?

Collectives™ on Stack Overflow

Mongodb query based on item at specific position in array

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