Query to get data not present in multiple arrays

Question

Hi I have User Schema like this:-

var userSchema   = new Schema({
    name: {type: String, default: null},
    location: {
      type: { type: String },
      coordinates: [Number],
    },
    sentFriendRequests: [
        {type: Schema.Types.ObjectId, ref: 'user'}],
    receivedFriendRequests: [
        {type: Schema.Types.ObjectId, ref: 'user'}] 
});

It is working good for all the requirements. I am searching nearby users with this query:-

User.aggregate(
      [{
        $geoNear: {
          near: { type: "Point", coordinates: [ longitude , latitude ] },
          distanceField: "dist.calculated",
          num: 5,
          spherical: true
        }
      }], function(err, nearByUsers){
         console.log(nearByUsers);
      })

The above query is working very good But now i want to search only the users who are not my in my friends array and not in both sent and received friend request array.

Tom Slabbaert · Accepted Answer · 2019-05-10 09:11:56Z

1

Well assuming you have the user document (because you're using its coordinates) then just add a $match to filter out the users before the $geonear phase.

{ 
  $match: {
         $and: [
           { _id: {$nin: user.sentFriendRequests},
           { _id: {$nin: user.receivedFriendRequests}
          ]
    }
}

answered May 10, 2019 at 9:11

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

1 Comment

gourav sarswa Over a year ago

Thank you @tom slabbaert. It works but If i use it before $geonear then it gives a warning that $geonear is only valid as the first stage in the pipeline. Then i used it after the $geonear phase and it works.

Collectives™ on Stack Overflow

Query to get data not present in multiple arrays

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related