chukaofili / sails-pager Goto Github PK

Hey @chukaofili

pager.paginate(OrgUnitRelationship, queryString , input.currentPage, input.perPage, [], 'createdAt', function(err, records) {
      console.log("pager getOrgs err: ", err, " result: ", records)
      if (!Utils.isEmpty(err)) {
        return cb({
          'statusCode': 200,
          'errorMessage': "Error retrieving Orgs."
        });
      }

      return cb(null, records);
    });

I want to pass queryString as an sql query

"eg: select o.*, u.id from order o join user u on o.user_id = u.id"

How can I do that?

Hi, i've found a problem on the currentPage attribute, first the new sails version 1.4.3 sets a warning :

pagination { page: 3, limit: 20 }
Deprecation warning: Passing in a dictionary (plain JS object) to .paginate()
is no longer supported -- instead, please use:

.paginate(pageNum, pageSize)

(In the mean time, interpreting this as page #3...)

And inside the pagination function it takes page:1 as page:2, so i changed my own code to set it to 0 instead of 1.

I'm getting this error while trying sails-pager.

Unhandled rejection TypeError: model.count is not a function

Here is my controller:
module.exports = {
list: function (req, res) {
var perPage = req.query.per_page;
var currentPage = req.query.page;
var conditions = {active: 1};
pager.paginate('FileMaster', conditions, currentPage, perPage, false, 'createdAt DESC', function(err, records){
if(err){
res.send(err);
}
res.send(records);
});

},

};