search

alwint3r / sequelize-datatable-node

MIT License
11 stars 12 forks source link

Search is not working in sqlite adapter #11

Closed carlost89 closed 4 years ago

carlost89 commented 4 years ago

"sequelize": "^3.35.1", "sequelize-datatables": "^1.2.1", "sqlite3": "^4.1.1", node: v10.18.0

When I try to search content No Results is shown in the table and the query that is executed is this:

Executing (default): PRAGMA TABLE_INFO(table_name); Executing (default): SELECT count() AS count FROM table_name AS table_name; Executing (default): SELECT count() AS count FROM table_name AS table_name WHERE 0 = 1;

Everything else is working with this package.

I appreciate any help you can offer me. Thanks.

carlost89 commented 4 years ago

Update: i just made some modifications in table creation using sequelize models en everything is working perfect.

Thanks.