sails-hook-datatable
A sails hook for working with Jquery datatables.
Install
npm i sails-hook-datatable --save
Support
This hook supports jquery DataTables 1.10+. If your working with a legacy version, see https://datatables.net/manual/server-side#Legacy for congiuration.
Usage
Send a GET
or POST
to /datatable/:model
to use
NOTE: Always set column.data
as showing in example below as sails.js
Always respond with an array of object [{"name":"foo"}, {"name":"bar"}]]
not literals like
[["boy","foo"], ["girl","bar"]]
. You can also set column.data = country.state.city
where country
is the column name. This would be handle well by both this hook and datatable.
//Example where *account* is the model name //ajax; //response "draw": 1 "recordsTotal": 57 "recordsFiltered": 57 "data": name: 'Damian' country: state: "New york" name: 'Sam' country: state: "Benin" name: 'Robophil' country: state: "London" name: 'Ovie' country: state: "Paris"
To view attributes in a model, send a GET
to /datatable/column-names/:model
to fetch the attributes for that model. See response below
columns: 'id' 'firstname' 'lastname'
Issues or Missing implementation
Create an issue to mention a bug or feature request. Fixed something? Send a PR
Liscence
MIT