MongoDb RunCommand to query embedded array

Question

I need to use "db.RunCommand" to get an item from an array embedded into a collection. I am just starting MongoDB and I am having difficulty looking into the MongoDB documentation since i can't find much examples using directly the "RunCommand" method.

So if i have this example

[
   {
     "Brand": {
         "Name": "Brand name 1",
         "Products": [
            {
                 "Product":  "Product 1",
                 "Price": 20.33
            },
             // i need to get only the following object
            { 
                 "Product":  "Product 2",
                 "Price": 10.33
            },
            {
                 "Product":  "Product 2",
                 "Price": 15.33
            }
         ]
      }
   }
]

So how can i construct the query into the "RunCommand(--query here--)" to get only "Product 2" ? So the result would be

{ 
   "Product":  "Product 2",
   "Price": 10.33
}

If is needed, i am using C# .net Core with MongoDB Driver

Greg Eremeev · Accepted Answer · 2020-12-06 20:16:18Z

1

db.runCommand({
    aggregate: "your_collection",
    "pipeline": [
        {$match: {"_id": ObjectId("5fcd2d3b08c6590a0cd04630")}},
        {$project: {
            _id: 0, "products": {"$arrayElemAt": ["$a.Brand.Products", 0]}}}, 
        {$project: {"products": {"$arrayElemAt": ["$products", 1]}}}],
    cursor: {}})

answered Dec 6, 2020 at 20:16

Greg Eremeev

1,8505 gold badges25 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

MongoDb RunCommand to query embedded array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related