时间戳

首页 > 解决方案 > 猫鼬使用跳过和限制填充数组

node.js - 猫鼬使用跳过和限制填充数组

问题描述

型号是

const mongoose = require('mongoose')
const Schema = mongoose.Schema

var UserActivitySchema = new Schema({
    author: {type: mongoose.Schema.Types.ObjectId, required: true, unique: true, ref: 'user'},
    readHistory: [{articleid: {type: mongoose.Schema.Types.ObjectId, ref: 'article'}, date_read: {type: Date, default: Date.now()}}],
    watchHistory: [{videoid: {type: mongoose.Schema.Types.ObjectId, ref: 'video'}, date_watch: {type: Date, default: Date.now()}}],
    searchHistory: [{query: String, date:{type: Date, default: new Date()}}]
})

module.exports = mongoose.model('useractivity',UserActivitySchema, 'useractivities')

在这里，我想获取我使用过查询的 readHistory

   if (req.query.page) var page = parseInt(req.query.page);
else var page = 1;
UserActivity.findOne({author: req.client.userId}).select('readHistory')
.populate({path: 'readHistory.articleid', select: 'title description views thumbnailURI', options: { skip: (page-1)*10, limit: 10}, populate: {path: 'author', select: 'displayName -_id'}})
.exec().then(activity=>{
    if (!activity || activity.readHistory.length <= 0)
        res.json({success: false, message: 'You have not read any article yet.'})
    else {
        res.json({success: true, readHistory: activity.readHistory})
    }
}).catch(err=>{
    res.json({success: false, message: err.message})
})

但它返回数组中的所有文档。如何解决这个问题？

标签： node.jsmongodbmongoose

解决方案

推荐阅读