How to return matched document from Array of object

Question

I am trying to filter the products from the product collection based on price.

Current Product Collection:

[
{
  _id: ObjectId("56f277b1279871c20b8b4566"),
  product_name:'sample product 1',
  product_items:[
         {
            product_price: 50.99,
            product_item_no: '123456789',
            product_images:['default.png']
          },
          {
            product_price: 11.99,
            product_item_no: '683456789',
            product_images:['default2.png']
          }
       ],
       product_status_is_active: true,

},
{
  _id: ObjectId("56f277b1279871c20b8b4567"),
  product_name:'sample product 2',
  product_items:[
         {
            product_price: 12.99,
            product_item_no: '45678923',
            product_images:['default2.png']
          },
          {
            product_price: 66.99,
            product_item_no: '683456789',
            product_images:['default4.png']
          }
       ],
       product_status_is_active: true,
}
]

mongoose query:

{
     '$match': {
       product_status_is_active: true,
       product_items: { '$elemMatch': { product_price: { '$gte': 60, '$lte': 100 } } }
    }
  },

Current Output:

{
  _id: ObjectId("56f277b1279871c20b8b4567"),
  product_name:'sample product 2',
  product_items:[
         { // This object should not display
            product_price: 12.99,
            product_item_no: '45678923',
            product_images:['default2.png']
          },
          {
            product_price: 66.99,
            product_item_no: '683456789',
            product_images:['default4.png']
          }
       ],
       product_status_is_active: true,
}

Expecting output like:

{
  _id: ObjectId("56f277b1279871c20b8b4567"),
  product_name:'sample product 2',
  product_items:[
          {
            product_price: 66.99,
            product_item_no: '683456789',
            product_images:['default4.png']
          }
       ],
       product_status_is_active: true,
}

But the Output of my Query contains also the nonmatching product_price.

How I can force MongoDB to return only the product_price, which matched my query?

Greetings and thanks.

Does this answer your question? Retrieve only the queried element in an object array in MongoDB collection — Alex Blex
– Alex Blex, Commented Sep 23, 2020 at 8:46

varman · Accepted Answer · 2020-09-23 09:24:38Z

1

You can achieve this with aggregation.

Match the product_status_is_active:true
Use $filter to filter the array based on condion
Match aging to empty product_items array

The aggregation stages are

[
  {
    $match: {
      "product_status_is_active": true
    }
  },
  {
    $addFields: {
      product_items: {
        $filter: {
          input: "$product_items",
          cond: {
            $and: [
              {
                $gte: [
                  "$$this.product_price",
                  60
                ]
              },
              {
                $lte: [
                  "$$this.product_price",
                  100
                ]
              }
            ]
          }
        }
      }
    }
  },
  {
    $match: {
      product_items: {
        $ne: []
      }
    }
  }
]

Working Mongo playground

answered Sep 23, 2020 at 9:24

varman

8,9326 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

How to return matched document from Array of object

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