Nested Query on mongodb not working [duplicate]

Question

Structure of Document:

Mongoose Schema:

var mongoSchema = new Schema({
name:  String,
description: String,
location: { lat: Number, long: Number },
images: [String],
blocks: { text: String, logo: String },
subLocations: {
    name: String,
    description: String,
    location: {
         lat: Number,
         long: Number
    },
    images: [String]
    }
});

Following Query does not work:

mongooseModel.find().
   where('location.lat').equals(18.710145).
   exec(function(err, response) {
}

While this query does work:

mongooseModel.find().
   where('lat').equals("18.710145").
   exec(function(err, response) {
}

Any guidance?

matias elgart · Accepted Answer · 2017-09-19 18:24:46Z

0

the datatype of the nested lat (location.lat) is a String (look at your embedded image, far right column). that's why your first query didn't work -- you're comparing a Number to a String.

answered Sep 19, 2017 at 18:24

matias elgart

1,19113 silver badges19 bronze badges

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

1 Comment

Aakash Thakkar Over a year ago

But I verified that it is casted as a number due to the mongoose defined schema. Also even after converting it to "18.710145" the query does not return any results.

Manish Joshi · Accepted Answer · 2017-09-19 18:29:58Z

0

Please try below query to find out your result.

db.myCollection.find( { $where: {"location":{"lat":"18.710145"}} } );

answered Sep 19, 2017 at 18:29

Manish Joshi

9313 bronze badges

1 Comment

Aakash Thakkar Over a year ago

This isnt using mongoose, its via the MongoDbClient right?

Collectives™ on Stack Overflow

Nested Query on mongodb not working [duplicate]

2 Answers 2

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Linked

Related