node-datatable

node-datatable copied to clipboard

Well, there are a few references, but builder.js has some references in `/* Example datatable querystring ....` Regex wasn't working for me. We were using this for SQLite. I realized...

bean5

antu12

Fix(recordsTotal): do not use search string for total count

1

Hi, This PR fixes https://github.com/jpravetz/node-datatable/issues/21 It adds a new parameter to `buildCountStatement` and `buildWherePartial` private functions, so that we can differentiate `recordsTotal` and `recordsFiltered` built queries. See it in action:...

ghybs

This PR fixes https://github.com/jpravetz/node-datatable/issues/19 It accepts `column.orderable` and `column.searchable` options as booleans (as passed by DataTables in the `requestQuery`), instead of expecting only a string value. See it in action:...

ghybs

Same output for all Query Builder

6

I'm getting same output for all the method calls from generate.js, am I missing anything? Called 1 Queries: {"recordsTotal":"SELECT COUNT(id) FROM Orgs","select":"SELECT * FROM Orgs"} Called 2 Queries: {"recordsTotal":"SELECT COUNT(id)...

nikunj-digicorp

When using DataTables "search" input field, node-datatable correctly builds 2 count queries (`recordsTotal` and `recordsFiltered`). However, those 2 queries are always identical. Live demo: https://plnkr.co/edit/PZiw9h5z0AgqSAQIfcXM?p=preview It seems that the `buildCountStatement`...

ghybs

npm module

3

Cannot find it on npm.

exebook

Warning about injection attacks

1

Your comment in the README: > A more thorough SQL injection security review Had given me the impression that there was preventative measures already in place to prevent injection. Thankfully...

brynnbp