mongodb - 有没有办法对mongodb中的列进行排序？

Question

我正在学习 MongoDB，我遇到了一件让我有点恼火的事情。

假设我有这个系列:

[
  {
    _id: ObjectId("XXXXXXXXXXXXXX"),
    name: "Tom",
    followers: 10,
    active: true
  },
  {
    _id: ObjectId("XXXXXXXXXXXXXX"),
    name: "Rob",
    followers: 109,
    active: true
  },
  {
    _id: ObjectId("XXXXXXXXXXXXXX"),
    name: "Jacob",
    followers: 2,
    active: false
  }
]

然后我使用以下命令将 name 列重命名为 username:

db.getCollection('users').update({}, { $rename: { "name" : "username" }}, false, true)

现在 username 属性位于记录的末尾，示例:

[
  // ... rest of collection has the same structure
  {
    _id: ObjectId("XXXXXXXXXXXXXX"),
    followers: 109,
    active: true,
    username: "Rob"
  }
  //  ... rest of collection has the same structure
]

如何防止这种情况发生或如何按特定顺序排列它们？这在 Robo/Studio 3T 中工作是令人气愤的。我有一个包含大约 15 列的集合，由于这个原因，现在在 GUI 中出现了乱序

Answer 1

The $rename operator logically performs an $unset of both the old name and the new name, and then performs a $set operation with the new name. As such, the operation may not preserve the order of the fields in the document; i.e. the renamed field may move within the document.

Documentation

这是来自 version 2.6 的行为

由于它是基于 JSON 的，因此您可以轻松获取任何字段。而且您的列非常少。