Using a where on an array with id's inside aggregate mongodb

Question

Hi im really struggling finding a solution to this.

Im trying to see if an array contains a value that I give

I want all tickets of a specific organization.

The organization is saved in the user (Creator) in an array named organizations.

Models

ticket {
    creator: "ObjectId"
}

user {
    organizations: ["ObjectId", "ObjectId"]
}

This is what I have now

    Ticket.aggregate([
        {
            "$lookup": {
                "from": User.collection.name,
                "localField": "creator",
                "foreignField": "_id",
                "as": "creator"
            }
        },
        { "$unwind": "$creator" },
        { "$match": { "creator.organizations": {
            "$elemMatch": {"$in": ["60a77d5b57d8c960829a0343"]}}}
        },
        { "$set": {"creator": "$creator._id"}},
    ])

This doesn't work tho

I read that you can't use $elemMatch inside an aggregate because its a query. How do I achieve this? I've seen people saying to use a $filter but I have no clue how to make that.

$elemMatch is not required, because you have already unwind the creator array, just try { $match: { "creator.organizations": {"$in": [ObjectId("60a77d5b57d8c960829a0343")]} } } — turivishal
– turivishal, Commented May 21, 2021 at 15:54

Lahiru Tennakoon · Accepted Answer · 2021-05-21 18:11:55Z

1

$elemMatch is not required here. This can be achieved only using $match as shown below.

const mongoose = require("mongoose");

Ticket.aggregate([{
    "$lookup": {
      "from": User.collection.name,
      "localField": "creator",
      "foreignField": "_id",
      "as": "creator"
    }
  },
  {
    "$unwind": "$creator"
  },
  // Modified code
  {
    "$match": {
      "creator.organizations": mongoose.Types.ObjectId("60a77d5b57d8c960829a0343")
    }
  },
  {
    "$set": {
      "creator": "$creator._id"
    }
  },
])

edited May 21, 2021 at 18:11

answered May 21, 2021 at 17:51

Lahiru Tennakoon

6471 gold badge6 silver badges8 bronze badges

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

2 Comments

Jan Over a year ago

That just sends an empty array. I double checked the objectId from organizations and it should return a ticket.

Lahiru Tennakoon Over a year ago

Add the objectId from organizations as a mongoose ObjectId (instead of a string). I modified the answer to reflect this.

Collectives™ on Stack Overflow

Using a where on an array with id's inside aggregate mongodb

Hi im really struggling finding a solution to this.

Im trying to see if an array contains a value that I give

Models

This is what I have now

This doesn't work tho

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Hi im really struggling finding a solution to this.

Im trying to see if an array contains a value that I give

Models

This is what I have now

This doesn't work tho

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related