Sails.Js - How I do pagination in sails.Js

javascript node.js sails.js waterline
sasitha999 picture sasitha999 · Oct 30, 2014 · Viewed 16k times · Source

I want to create paginated table using sails.js, mongodb and waterline-ORM.

Is there a any specific way to do pagination in sails.js?

Answer

Martin Malinda picture Martin Malinda · Oct 30, 2014

http://sailsjs.org/#/documentation/concepts/ORM/Querylanguage.html

Model.find().paginate({page: 2, limit: 10});

Model.find({ where: { name: 'foo' }, limit: 10, skip: 10 });

If you want the pagination to work asynchronously, its very easy to do with JQUERY $$.getJSON and on the server res.json();

Theres a lot of info in waterline and sails docs.

Related questions

Sails.js best practice in using transactions with promises (Postgres)

I'm using sails 0.9.16 with Postgres and my question is: what is the best way to execute transaction using current API with promises? May be there is something better than: Model.query('BEGIN TRANSACTION', function (err) { if (err) { next(err); } else { …

Read More
Waterline ORM (sails.js) conditions with NOT Equal in query

How can I write a NOT Equal condition in Waterline? This code: Users .count() .where({ id: { '!=': req.params.id}, lastname: req.body.lastname }) Does nothing... (disk adapter in sails.js)

Read More
How to use Model.query() with promises in SailsJS/Waterline?

I'm having issues with Sails.JS 0.9.8. I would like to use promises with the Model.query() function (I use sails-mysql adapter). This code will work : User.findOne({ email: email }) .then(function(user) { console.log(user); }); but this one won't User.…

Read More