猫鼬:按嵌套字段排序 [英] Mongoose: Sort by nested field

问题描述

我正在尝试使用称为orderIndex的嵌套字段对数据进行排序.

I'm trying to sort the data with nested field, called orderIndex.

router.get("/", (req, res) => {
  Book.find({ _id: req.params.id })

    .sort({ 'Book.chapters.orderIndex': "asc" }) //doesn't work

    .then(books => {
      res.render("books/index", {
        books: books
      })
    });
});

Book外观的示例:

//Book
    {
        "_id": {
            "$oid": "1234517fe46cf86900af82f"
        },
        "chapters": [
            {                 
                "_id": {
                    "$oid": "a1"
                },
               "title": "first book",
               "orderIndex": "1",
            },
             {                 
                "_id": {
                    "$oid": "5678798be6bb05e4427ee65"
                },
               "title": "second book",
               "orderIndex": "2",
            },
            //..some more
        ]
    }

推荐答案

更改

.sort({ 'Book.chapters.orderIndex': "asc" })

收件人

.sort({ 'chapters.orderIndex': 1 })

看看这个链接

sort 文档.

这篇关于猫鼬:按嵌套字段排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！