MongoDB : Match with element in an array

Question

I am working on a collection called Publications. Each publication has an array of objectives which are ids. I have also a custom array of objectives hand written. Now, I want to select all the publications that contains at least one element of the custom objectives array in their objectives. How can I do that ?

I've been trying to make this works with '$setIntersection' then '$count' and verify that the count is greater than 0 but I don't know how to implement this.

Example :

publication_1: {
     '_id': ObjectId("sdfsdf46543")
     'objectives': [ObjectId("1654351456341"), ObjectId("123456789")]
}

publication_2: {
     '_id': ObjectId("sdfs216546543")
     'objectives': [ObjectId("1654351456341"), ObjectId("46531132")]
}

custom_array = [ObjectId("123456789"), ObjectId("2416315463")]

The mongo query should return publication_1.

glinda93 · Accepted Answer · 2020-07-02 16:06:27Z

1

You can do like the following:

db.publications.find({
  "objectives": {
    "$in": [
      ObjectId("123456789"),
      ObjectId("2416315463")
    ]
  }
})

Notice: "123456789" is not a valid ObjectId so the query itself may not work. Here is the working example

Mongodb playground link: https://mongoplayground.net/p/MbZK99Pd5YR

answered Jul 2, 2020 at 16:06

glinda93

8,5297 gold badges51 silver badges88 bronze badges

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

Comments

ibrahimijc · Accepted Answer · 2020-07-02 15:52:53Z

0

objectives is an array of objects, I guess you can just query that field directly:

let custom_array = [ObjectId("123456789"), ObjectId("2416315463")];
// You can search the array with $in property. 
let result = await Model.find({ objectives: {$in : custom_array} })

answered Jul 2, 2020 at 15:52

ibrahimijc

3413 silver badges12 bronze badges

Collectives™ on Stack Overflow

MongoDB : Match with element in an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related