searchable doesn't work with numeric columns

[holoyan]

Laravel 8 posgre

any way to use searchable() method with numeric columns??

when I use like this it throws exception

            NumberColumn::name('id')
                ->label('ID')
                ->searchable()
                ->defaultSort('desc')
                ->sortBy('id'),

SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1: ...ount(*) as aggregate from "mytable" where (((LOWER(mytab... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from "mytable" where (((LOWER(mytable.id) like %5%))))

any solution?