How to convert array to string in mongodb

Question

I have below schema

{
 id: 123,
 values:[
   {valueId: "12444", name: "asd"},
   {valueId: "555", name: "www"},
 ]
}

i want to convert it into (combine name into single string)

{
 id: 123,
 values: "asdwww"
}

i have tried below aggregate which puts all name value in an array

$project: {
      attributes: {
        "$map": {
          "input": "$attributes",
          "as": "attr",
          "in": {
            "id": "$$attr.id",
            "values": "$$attr.values.name"
          }
        }
      }
    },

which makes it into

{
 id: 123,
 values:[
     "asd",
     "www"
   ]
}

i want to have values as single string value as "asd,www" or "asdwww"

mickl · Accepted Answer · 2020-11-03 09:20:38Z

5

You need $reduce instead of $map:

db.collection.aggregate([
    {
        $project: {
            _id: 1,
            values: {
                $reduce: {
                    input: "$values",
                    initialValue: "",
                    in: { $concat: [ "$$value", "$$this.name" ] }
                }
            }
        }
    }
])

Mongo Playground

Here's an example which shows how to handle delimiters

answered Nov 3, 2020 at 9:20

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

How to convert array to string in mongodb

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