How to filter the response from mongoDB, so nested arrays will include only items that meet a condition?

Question

My documents look like this

 {
  "_id": {
    "$oid": "62825f71005ce00c5f0235c1"
  },
  "user": "jon",
  "roles": {
    "User": 2001,
    
  },
 
  "STOCK ": [
    {
      "sku": "BLACK-M",
      "productname": "BLACK",
      "sendout": 0,
      "recived": 1,
      "totalinstock": 40,
      "location": "B32",
      "_id": {
        "$oid": "62826016005ce00c5f0235c8"
      }
    },
  
    {
      "sku": "CJNS",
      "productname": "89796363",
      "sendout": 0,
      "recived": 45,
      "totalinstock": 0,
      "location": "B232",
      "_id": {
        "$oid": "62836f2d56b4f1ac79c99b8d"
      }
    }
  ],
   "ORDERS": [
    {
      "date": {
        "$date": "2022-06-02T15:23:58Z"
      },
      "OrderNumber": "745607",
      "City": "xxxxx",
      "Address": "yyyyyy",
      "Phone": "8678678678",
      "Name": "Holly ",
      "Trackingnumber": 40,
      "ZipCode": 00000,
      "Province": "New ",
      "Quantity": [
        1
      ],
      "Product_Name": [
        " pants pants"
      ],
      "SKU": [
        "CJNS"
      ],
      "_id": {
        "$oid": "6298d61ba6eeec72b78332a7"
      }
    },
    {
      "date": {
        "$date": "2022-06-02T15:23:58Z"
      },
      "OrderNumber": "748840",
      "City": "xxxxx",
      "Address": "yyyyyy",
      "Phone": "354353454",
      "Name": "Michael",
      "Trackingnumber": 0,
      "ZipCode": 00000,
      "Province": "North",
      "Quantity": [
        1
      ],
      "Product_Name": [
        " pants pants"
      ],
      "SKU": [
        "CJNS"
      ],
      "_id": {
        "$oid": "6298d61ba6eeec72b78332a9"
      }
    }
  ]
}

I successful to return all the objects in STOCK or all the objects in ORDERS Through this query

const foundUser=  await User.find({"user":req.body.user},("Orders") ).exec()

Now I want to filter the response to include only items where "Trackingnumber" is different from 0

For the sample data I expect to receive only

{
      "date": {
        "$date": "2022-06-02T15:23:58Z"
      },
      "OrderNumber": "748840",
      "City": "xxxxx",
      "Address": "yyyyyy",
      "Phone": "354353454",
      "Name": "Michael",
      "Trackingnumber": 0,
      "ZipCode": 00000,
      "Province": "North",
      "Quantity": [
        1
      ],
      "Product_Name": [
        " pants pants"
      ],
      "SKU": [
        "CJNS"
      ],
      "_id": {
        "$oid": "6298d61ba6eeec72b78332a9"
      }
    }

rickhg12hs · Accepted Answer · 2022-06-05 06:47:13Z

2

You can use an aggregation pipeline with a $filter for this:

db.collection.aggregate([
  {
    $match: {
      "user": "jon"
    }
  },
  {
    $project: {
      ORDERS: {
        $filter: {
          input: "$ORDERS",
          as: "item",
          cond: {$ne: ["$$item.Trackingnumber", 0]}
        }
      }
    }
  }
])

Playground example

edited Jun 5, 2022 at 6:47

rickhg12hs

12k6 gold badges31 silver badges50 bronze badges

answered Jun 3, 2022 at 8:02

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Comments

Harishbn · Accepted Answer · 2022-06-03 08:23:58Z

-1

User.find({"Orders" : {"Trackingnumber": 0} })

answered Jun 3, 2022 at 8:23

Harishbn

971 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to filter the response from mongoDB, so nested arrays will include only items that meet a condition?

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