Postgresql Datatable search

Postgresql Datatable search

Gerald.RagerGerald.Rager Posts: 19Questions: 3Answers: 0

Hello,

if i search in the datable search field (i search the id of a database row)

i got this failure

DataTables warning: table id=customer - SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown
LINE 1: SELECT COUNT(id) as cnt FROM test WHERE (id like $1 )
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

thanks for any help

This discussion has been closed.