Filtering array items from items in another array in mongodb aggregation

Question

I have managed to create an aggregate which returns two array in a document like so:

"b": [
                {
                    "_id": "6258bdfe983a2d31e1cc6a4b",
                    "booking_room_id": "619395ba18984a0016caae6e",
                    "checkIn_date_time": "2022-04-16",
                    "checkOut_date_time": "2022-05-17"
                }
            ]

"r": [
                {
                    "_id": "619395ba18984a0016caae6e",
                }
            ]

I want to remove the item from r if _id in r matches booking_room_id in b.

Also, since these array exist inside a parent document. I want to remove the parent document from the query if r is empty after performing the filter.

YuTing · Accepted Answer · 2022-04-15 01:33:28Z

1

Use $expr and $filter

db.collection.aggregate([
  {
    $match: {
      $expr: {
        $ne: [
          {
            $filter: {
              input: "$r",
              as: "r",
              cond: {
                $not: { $in: [ "$$r._id", "$b.booking_room_id" ] }
              }
            }
          },
          []
        ]
      }
    }
  },
  {
    $set: {
      r: {
        $filter: {
          input: "$r",
          as: "r",
          cond: {
            $not: { $in: [ "$$r._id", "$b.booking_room_id" ] }
          }
        }
      }
    }
  }
])

mongoplayground

answered Apr 15, 2022 at 1:33

YuTing

6,6692 gold badges8 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Filtering array items from items in another array in mongodb aggregation

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