Pagination on mongoDB aggregations [Node.js]

Question

I have query something like this:

Message.aggregate([{
        "$match": {
          $or: [{
            "to": userId
          }, {
            "from": userId
          }]
        }
      },
      {
        "$sort": {
          "createDate": -1
        }
      },
      {
        "$group": {
          "_id": "$conversationId",
          "from": {
            "$first": "$from"
          },
          "to": {
            "$first": "$to"
          },
          "content": {
            "$first": "$content"
          },
          "createDate": {
            "$first": "$createDate"
          },
          "unreaded": {
            "$sum": {
              "$cond": {
                if: {
                  $and: [{
                      "$eq": [
                        "$unreaded", 1
                      ]
                    },
                    {
                      "$eq": ["$to", userId]
                    }
                  ]
                },
                then: 1,
                else: 0
              }
            }
          }

        }

      },
      {
        "$sort": {
          "createDate": -1
        }
      },
      {
        "$lookup": {
          "from": "users",
          "localField": "from",
          "foreignField": "_id",
          "as": "from"
        }
      },
      {
        "$lookup": {
          "from": "users",
          "localField": "to",
          "foreignField": "_id",
          "as": "to"
        }
      },
      {
        "$unwind": {
          "path": "$from"
        }
      },
      {
        "$unwind": {
          "path": "$to"
        }
      },
      {
        "$project": {
          "from.firstName": "$from.firstName",
          "from.lastName": "$from.lastName",
          "from.picture": "$from.picture",
          "to.firstName": "$to.firstName",
          "to.lastName": "$to.lastName",
          "to.picture": "$to.picture",
          "content": 1,
          "createDate": 1,
          "unreaded": 1,
          "reciver": {
            "$cond": {
              if: {
                "$eq": ["$from._id", mongoose.Types.ObjectId(userId)]
              },
              then: {
                "firstName": "$to.firstName",
                "lastName": "$to.lastName",
                "_id": "$to._id"
              },
              else: {
                "firstName": "$from.firstName",
                "lastName": "$from.lastName",
                "_id": "$from._id"
              }
            }
          }
        }
      },
      {
        "$limit": 50
      }

I am able now to limit records to 50 per request but problem is when I try to make pagination... I get this error when I try to add skip next to limit:

Error: Arguments must be aggregate pipeline operators

any idea how can I do that?

Your args are not valid. You should put $limit as an element in array of aggregation pipelines. — Greg Eremeev
– Greg Eremeev, Commented May 5, 2017 at 10:17

Greg Eremeev · Accepted Answer · 2017-05-05 10:24:24Z

1

Check your args and correct mistake.

Message.aggregate([{"$match": {$or: [{"to": userId}, {"from": userId}]}}, ..., {$skip: 1}, {$limit: 1}])

edited May 5, 2017 at 10:24

answered May 5, 2017 at 10:21

Greg Eremeev

1,8505 gold badges25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Greg Eremeev Over a year ago

Add skip operator

Greg Eremeev Over a year ago

You have mistake in syntax, nothing else

Collectives™ on Stack Overflow

Pagination on mongoDB aggregations [Node.js]

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related