Query to get all posts of topics

techy mast

Hello, please help me with mongo query to get all posts by topic id

Brophy

Do you actually need to do this via mongo?

Could you make use of the API which would return it all as JSON.

Every route in NodeBB has a read-only API accessible by prepending the route with /api

If you want to POST to NodeBB, you'll want to look at the write API, which has its own documentation

<baris>

const topicId = 5;
const keys = db.objects.find({ _key: "tid:" + topicId + ":posts" }).map(i => 'post:' + i.value);
printjson(db.objects.find({ _key: { $in: keys } }).toArray());

You can save this in a file called query.js and then execute it with mongo localhost:27017/mydb query.js

It will output something like

[
        {
                "_id" : ObjectId("5547ae6a65190fe21225ec2b"),
                "_key" : "post:124",
                "pid" : 124,
                "uid" : 47,
                "tid" : 5,
                "content" : "I like it too :)",
                "timestamp" : 1376791225638,
                "bookmarks" : 2
        },
        {
                "_id" : ObjectId("5547aee765190fe212296f10"),
                "_key" : "post:18",
                "pid" : 18,
                "uid" : 2,
                "tid" : 5,
                "content" : "Thank you :)",
                "timestamp" : 1373686442781
        }
]