ypnos-web / cakephp-datatables

CakePHP3 Plugin for DataTables plug-in for jQuery
MIT License
27 stars 24 forks source link

Fix postgres search error with integer fields #47

Closed ThomasNucleus closed 6 years ago

ThomasNucleus commented 6 years ago

LIKE operation does not work with integers on a postgres database, breaking the search functionality.

Casting the field to text fixes this, however this may cause issues on other database systems? Can someone with more knowledge review.

ypnos-web commented 6 years ago

Hello,

thank you for your efforts. This problem is already fixed in devel branch. I think it is time to bump master to devel.

Could you try the devel branch and give feedback if the solution there works for you?

See this related commit: https://github.com/ypnos-web/cakephp-datatables/commit/5cc357d960f0680b4dd006f581e4e4412ad4d3e9

ThomasNucleus commented 6 years ago

Ignore this pull request, refer to #48