How to remove empty string and arrays from objects inside an array? MongoDB Aggegation

Question

I want to delete the empty strings and empty arrays within a document. Is there a way to do this with the MongoDB Aggregation Framework? Here is an example of an incoming document:

"item": [{
    "array_objects":[{
        "text": '',
        "second_text": '',
        "empty_array": [],
        "empty_array_2":[],
    }]
}]

Tiya Jose · Accepted Answer · 2020-10-15 06:29:03Z

2

If you want to project all the fields that are not empty string or empty array, use $filter

You can try the below aggregation query:

db.collection.aggregate([
  {
    $unwind: "$item"
  },
  {
    $unwind: "$item.array_objects"
  },
  {
    $project: {
      item: {
        $arrayToObject: {
          $filter: {
            input: {
              $objectToArray: "$item.array_objects"
            },
            cond: {
              $and: [
                {
                  $ne: [
                    "$$this.v",
                    ""
                  ]
                },
                {
                  $ne: [
                    "$$this.v",
                    []
                  ]
                }
              ]
            }
          }
        }
      }
    }
  }
])

MongoDB playground

answered Oct 15, 2020 at 6:29

Tiya Jose

1,43915 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to remove empty string and arrays from objects inside an array? MongoDB Aggegation

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