skip += (messageTotal - total); const messageData = await Message.find({roomid: id}).skip(skip).sort({"time": -1}).limit(20).exec(); message.data = messageData.reverse(); res.json({
return Message.find( { roomid: item } ).sort({"_id": -1}).limit(20); })
console.log(typeof msgid); if(!msgid) { const messageData = await Message.find( { roomid }).sort({"_id": -1}).limit(20).exec(); message.data = messageData.reverse(); } else { const messageData = await Message.find({'_id': { '$lt': msgid }, roomid }).sort({"_id": -1}).limit(20).exec(); message.data = messageData.reverse();
contents.find(query) .sort(sort) .limit(limit) .select('category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path') .populate('user', 'nickname email') .populate('thumbnail', 'fileName description date') .exec(function (err, contents) { if (err) { err.type = 'database'; return callback(err); } contents = _.map(contents, function (content) { if (content.thumbnail) var thumbnailSrc = content.thumbnail.src; content = content.toObject(); if (_.get(content, 'category.path')) content.href = content.category.path + '/' + content.alias; if (content.thumbnail) content.thumbnail.src = thumbnailSrc; delete content.alias; delete content.reading.createAt; return content; }); callback(null, contents); });
.limit(limit) .select('category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path')
.sort('-date') .skip((currentPage - 1) * pageSize) .limit(pageSize) .select('fileName description date size quotes src') .exec(function (err, media) {
contents.find({ category: { $in: category.node }, status: 'pushed', deleted: false }) .sort('-date') .limit(50) .select('category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path') contents.find({ category: category._id, status: 'pushed', deleted: false, date: { $lte: new Date() } }) .sort('-date') .limit(50) .select('category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path')
contents.find({ category: column._id, status: 'pushed', deleted: false, date: { $lte: new Date() } }) .sort('-date') .limit(50) .select('category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path')
.sort('status -date') .skip((currentPage - 1) * pageSize) .limit(pageSize) .select('status category title alias user date reading thumbnail abstract extensions') .populate('category', 'name path')
Message.find(query) .limit(50) .sort({ createdAt: -1 }) .then(result => { res.status(200).json({ messages: result }); }) .catch(err => { console.log(err.message); res.status(500).json({ message: err.message }); });
function query(page,size,uid,callback) { var query = MessageModel.find({}); var condition = []; if(uid){ condition.push({"from_uid":uid}); condition.push({"to_uid":uid}); } var skip = (page - 1) * size; query.or(condition).skip(skip).limit(size).sort({"time":-1}).exec(callback); }
User.find({ _id: { $lt: req.body.lastId } }) .select("username date profilePicture") .sort({ date: -1 }) .limit(30) .then((users) => { return res.status(200).json({ users }); }) .catch((err) => res.status(500).json({ message: err.message }));
skip += (messageTotal - total); const messageData = await Message.find({roomid: id}).skip(skip).sort({"time": -1}).limit(20).exec(); message.data = messageData.reverse(); res.json({