mongoDB查询数组中的数组
PHPz
PHPz 2017-04-28 09:06:22
0
1
747
{
    "_id" : "1249",
    "auth" : {
        "_id" : "admin",
        "name" : "admin"
    },
    "content" : "亡官方的冷漠反应",
    "title" : "在上海一家外企工作。",
    "theme" : "bug",
    "dtype" : "all",
    "reply" : [ 
        {
            "discussname" : {
                "_id" : "wzb",
                "name" : "wzb"
            },
            "content" : "\t无言",
            "createtime" : ISODate("2004-08-03T15:05:00.000Z"),
            "floor" : "1",
            "reply" : [ 
                {
                    "replyname" : {
                        "_id" : "123",
                        "name" : "123"
                    },
                    "author" : "",
                    "content" : "不错哦",
                    "createtime" : ISODate("2016-01-13T08:08:10.081Z")
                }, 
                {
                    "replyname" : {
                        "_id" : "123",
                        "name" : "123"
                    },
                    "author" : "",
                    "content" : "jiayouo",
                    "createtime" : ISODate("2016-01-13T09:27:10.881Z")
                }, 
                {
                    "replyname" : {
                        "_id" : "123",
                        "name" : "123"
                    },
                    "author" : "回复 123",
                    "content" : "nihao",
                    "createtime" : ISODate("2016-01-13T09:27:25.681Z")
                }]
        },{
            "discussname" : {
                "_id" : "123",
                "name" : "123"
            },
            "floor" : "2",
            "content" : "好帅",
            "createtime" : ISODate("2016-01-16T11:04:07.917Z"),
            "reply" : [ 
                {
                    "replyname" : {
                        "_id" : "123",
                        "name" : "123"
                    },
                    "author" : "",
                    "content" : "很好",
                    "createtime" : ISODate("2016-01-16T11:05:21.036Z")
                }
            ]
        }
 }

像上面的字段,我这样查询:

db.getCollection('tribune').find({"_id":"1249"},{"reply":{"$elemMatch":{"floor":"1"}}})

取出来的里面的reply数组(就叫 A 吧),现在我想取数组A的前两个字段,要怎么做?

PHPz
PHPz

学习是最好的投资!

membalas semua(1)
小小卫

Tiada lagi Doudou, tiada lagi Doudou, tiada lagi Doudou, tiada lagi Doudou, tiada lagi Doudou, tiada lagi Doudou, tiada Doudou, tiada Doudou, tiada Doudou, tiada Doudou, tiada lagi

Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan