Mongo DB: Find nested array value

Question

I am working with node.js and trying to find array containing matching "productId" in the same document as matching "sale". I didn't find much in the mongo documentation regarding this.

{"_id":
    {"$oid":"601baf0e5c307422c0fa958c"},
    "sale":"Test Sale",
    "products":[
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ],
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ],
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ]
    ],
    "collectionProducts":["id","id","id"]
}

Gibbs · Accepted Answer · 2021-02-05 06:36:01Z

0

playground

db.collection.find({
  "sale": "Test Sale",
  products: {
    "$elemMatch": {//As you have nested arrays
      "$elemMatch": {
        "$elemMatch": {
          "$in": [
            "abc"
          ]
        }
      }
    }
  }
})

It's better to have better schema.

answered Feb 5, 2021 at 6:36

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

Collectives™ on Stack Overflow

Mongo DB: Find nested array value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related