Nested Query on mongodb not working

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?

score 0 · Answer 1 · answered Sep 19 '17 at 18:24

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 '17 at 18:24

matias elgart

1,123
12
18

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. – Aakash Thakkar Sep 19 '17 at 18:43

score 0 · Answer 2 · answered Sep 19 '17 at 18:29

0

Please try below query to find out your result.

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

answered Sep 19 '17 at 18:29

Manish Joshi

93
13

This isnt using mongoose, its via the MongoDbClient right? – Aakash Thakkar Sep 19 '17 at 18:44

Nested Query on mongodb not working

2 Answers2