首页 > 解决方案 > 如何在 pug 模板中迭代这个 mongodb json

问题描述

我想按以下格式迭代这个 mongodb json

index         date

 1        1/18/2019, 11:10:05 PM  
 2        1/18/2019, 11:10:19 PM
 3        1/18/2019, 11:13:29 PM 

这是我的 mongodb 代码

{
    "_id" : ObjectId("5c420f651967ea6623f96fb2"),
    "username" : "username",
    "type" : "history",
    "date" : [
        "1/18/2019, 11:10:05 PM",
        "1/18/2019, 11:10:19 PM",
        "1/18/2019, 11:13:29 PM",
        "1/18/2019, 11:14:41 PM",
        "1/18/2019, 11:21:07 PM",
        "1/18/2019, 11:21:26 PM",
        "1/18/2019, 11:22:02 PM",
        "1/18/2019, 11:22:46 PM",
        "1/18/2019, 11:23:35 PM",
        "1/18/2019, 11:24:58 PM",
        "1/18/2019, 11:25:40 PM",
        "1/18/2019, 11:27:29 PM",
        "1/18/2019, 11:32:30 PM"
    ]
}  

这是我的节点 js 代码

db.collection("test").find({username: req.session.login, type: 'history'}).toArray(function (err, docs) { 

res.render("history", {history: docs });

这不工作哈巴狗

table.table.table-hover.table-bordered.table-active
            thead
                tr
                    th Number
                    th(scope="col") Login Time
                each a,i in history.reverse()
                    tr
                        td=i+1
                        td=a.date

请帮助我如何正确执行我使用的 json stringify 方法不起作用

标签: node.jsjsonmongodbexpresspug

解决方案


您需要在 Pug 上添加另一个循环,它应该如下所示,

table.table.table-hover.table-bordered.table-active
        thead
            tr
                th Number
                th(scope="col") Login Time
            - var sno = 1;
            each a in history.reverse()
                each date in a.date
                    tr
                        td=sno++
                        td=date

推荐阅读