admin管理员组

文章数量:1022275

I have below schema

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

i want to convert it into (bine 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"

I have below schema

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

i want to convert it into (bine 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"

  • javascript
  • node.js
  • mongodb
  • aggregation-framework
Share Improve this question edited Nov 3, 2020 at 9:20 mickl 50.1k9 gold badges70 silver badges98 bronze badges asked Nov 3, 2020 at 9:16 Akash SalunkheAkash Salunkhe 3144 silver badges14 bronze badges
Add a ment  | 

1 Answer 1

Reset to default 4

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

I have below schema

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

i want to convert it into (bine 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"

I have below schema

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

i want to convert it into (bine 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"

  • javascript
  • node.js
  • mongodb
  • aggregation-framework
Share Improve this question edited Nov 3, 2020 at 9:20 mickl 50.1k9 gold badges70 silver badges98 bronze badges asked Nov 3, 2020 at 9:16 Akash SalunkheAkash Salunkhe 3144 silver badges14 bronze badges
Add a ment  | 

1 Answer 1

Reset to default 4

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

本文标签： javascriptHow to convert array to string in mongodbStack Overflow

版权声明：本文标题：javascript - How to convert array to string in mongodb - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745516183a2154066.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。