MongoDB: aggregation, array of objects to string value

Question

My question is pretty similar to: MongoDB Aggregation join array of strings to single string, but instead of pure Array, like: ['Batman', 'Robin'] I have Array of objects:

_id: 1,
field_value: [
  {
    _id: 2,
    name: "Batman"
  },
  {
    _id: 3,
    name: "Robin"
  }
]

I am trying to use $reduce but got error instead.

I want to receive the following result:

  _id: 1,
  field_value: "Batman, Robin" /** <= String value */

or at least array of property values:

  _id: 1,
  field_value: ["Batman", "Robin"] /** <= Array of strings (name property) */

My MongoPlayground data example

Does this answer your question: stackoverflow.com/questions/62346889/… ? — mickl
– mickl, Commented Aug 7, 2020 at 10:48

mickl · Accepted Answer · 2020-08-07 10:55:53Z

4

You need the same approach with $reduce, $$this represents a single field_value entity so you need $$this.name:

db.collection.aggregate([
    {
        $project: {
            field_value: {
                $reduce: {
                    input: "$field_value",
                    initialValue: "",
                    in: {
                        $concat: [
                            "$$value",
                            { $cond: [ { $eq: [ "$$value", "" ] }, "", "," ] },
                            { $toString: "$$this.name" }
                        ]
                    }
                }
            }
        }
    }
])

Mongo Playground

answered Aug 7, 2020 at 10:55

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

2 Comments

AlexZeDim Over a year ago

Yes, this exactly what I need it too. I also updated my question with MongoPlayground example data. So the real question is: I can accept is as an answer to the question (and I will do it, by default), or should I delete the whole question, because it's a duplicate?

mickl Over a year ago

You can accept since you were asking about an array of objects

Collectives™ on Stack Overflow

MongoDB: aggregation, array of objects to string value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related