mongodb-将字段名称插入字符串而不是获取值

发布于 2025-01-25 01:26:41 字数 539 浏览 0 评论 0原文

我想从已经存在的经度和纬度创建一个新的位置字段。

db.neigborhood.updateMany({}, {
$set: {
    "location": {
        "type": "Point",
        "coordinates": ["$longitude", "$latitude"]
    }   
}});

我编写了应该创建新字段的代码，但是问题是我将名称作为字符串而不是字段值。

{
  "_id": {
    "$oid": "626a01f1df85b4b2937ece2d"
  },
  "latitude": "10.4980067",
  "longitude": "-66.8335096",
  "location": {
    "type": "Point",
    "coordinates": [
      "$longitude",
      "$latitude"
    ]
  }
}

我做错了什么，因为我得到了“ $经度”而不是-66.8335096值？

原文

I want to create a new location field from already existing longitude and latitude.

db.neigborhood.updateMany({}, {
$set: {
    "location": {
        "type": "Point",
        "coordinates": ["$longitude", "$latitude"]
    }   
}});

I wrote this code that should create the new field, but the problem is that instead of the field values I get the names as strings.

{
  "_id": {
    "$oid": "626a01f1df85b4b2937ece2d"
  },
  "latitude": "10.4980067",
  "longitude": "-66.8335096",
  "location": {
    "type": "Point",
    "coordinates": [
      "$longitude",
      "$latitude"
    ]
  }
}

What am I doing wrong that I get "$longitude" instead of the -66.8335096 value?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

江心雾 2025-02-01 01:26:41

与带有聚合管道的更新。

db.neigborhood.updateMany({},
[
  {
    $set: {
      "location": {
        "type": "Point",
        "coordinates": [
          "$longitude",
          "$latitude"
        ]
      }
    }
  }
])

示例mongo playground

Works with Update with Aggregation Pipeline.

db.neigborhood.updateMany({},
[
  {
    $set: {
      "location": {
        "type": "Point",
        "coordinates": [
          "$longitude",
          "$latitude"
        ]
      }
    }
  }
])

Sample Mongo Playground

回复收藏 0 原文

~没有更多了~