Why won't this MongoDB query work?

Question

Is there a reason I'm unaware of that would cause this query to fail?

Specifically it's the features: {$in: featuresArray} part that causes the query to fail.

Collection.find({
  features: {
    $in: featuresArray
  },
  location: {
    $near : {
      $geometry : {
        type : 'Point',
        coordinates: [long, lat]
      }
    }
  }},
 {
   sort: {
     score: -1
   }
});`

The sort spec is wrong here. But what is the error you are getting that makes you think the addition of searching on the features field is causing the problem? Could do with more information in your post. — Neil Lunn
– Neil Lunn, Commented Oct 3, 2014 at 7:20
This is using a JS framework, not in the shell, so yeah, the sort() is different. — JohnAllen
– JohnAllen, Commented Oct 3, 2014 at 15:26
This question appears to be off-topic because it is about a silly mistake I made in my code. It had to do with nesting, so this was more an oversight/typo error. — JohnAllen
– JohnAllen, Commented Oct 3, 2014 at 15:50

Mithun Satheesh · Accepted Answer · 2014-10-03 07:11:29Z

2

As the docs for db.collection.find says, the second argument for the find should be for projection - ie. which all fields to return in the result. But here you are using the second paramater to sort the results.

I think it should be done like :

Collection.find({
    features: {
        $in: featuresArray
    },
    location: {
        $near : {
            $geometry : {
                type : 'Point',
                coordinates: [long, lat]
            }
        }
    }
}).sort({
    score: -1
});

answered Oct 3, 2014 at 7:11

Mithun Satheesh

27.9k14 gold badges80 silver badges103 bronze badges

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

2 Comments

JohnAllen Over a year ago

Can you delete your answer? I realized my silly mistake and fixed my code. Had added a field and so thus needed to do 'features.name': featuresArray now.

JohnAllen Over a year ago

This is using a JS framework, not in the shell, so yeah, the sort() is different

Collectives™ on Stack Overflow

Why won't this MongoDB query work?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related