Filament•15mo ago

function lower(bigint) does not exist on Table search on ID field

I have ID column as searchable, but it raises the following error: SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1

select count(*) as aggregate from "products" where (lower(id)::text like %iphone% or lower(name)::text like %iphone%)

select count(*) as aggregate from "products" where (lower(id)::text like %iphone% or lower(name)::text like %iphone%)

According to the source code, isSearchForcedCaseInsensitive() returns true because the DB engine is PostgreSQL https://github.com/filamentphp/filament/blob/612045cd618829749391cf90a93c29e830a10ee4/packages/tables/src/Columns/Concerns/InteractsWithTableQuery.php#L102)

GitHub

filament/packages/tables/src/Columns/Concerns/InteractsWithTableQue...

A collection of beautiful full-stack components for Laravel. The perfect starting point for your next app. Using Livewire, Alpine.js and Tailwind CSS. - filamentphp/filament

5 Replies

toeknee•15mo ago

Can you provide your resource code?

MAFOP•15mo ago

It is slightly big and has some sensitive information, which will take a lot of time to clean. Can I send it privately?

toeknee•15mo ago

sure make sure to send the list file too

MAFOP•15mo ago

@toeknee should I try to fix this?

toeknee•15mo ago

Feel free sorry I am struggling for time at@

Gaming

Programming

function lower(bigint) does not exist on Table search on ID field