Find and count all in Sails.js + Waterline

Question

Is there a way to do select query and count_all query via single method? For pagination purposes we need to know total number of items so we can calculate and show number of pages.

Answer 1

getLength: function(req, res) {
    Posts.find({}).exec(function(err, items){

        return items.length;
    });
}

Answer 2

Check out Sails.Js - How I do pagination in sails.Js for pagination in Waterline.

To get the total number of items, you can use:

Post.count().exec(function (err, nbOfInstances) {
    if(err) return res.negociate(err);

    return res.ok(nbOfInstances);
});