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

SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1

SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1

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%)

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()

isSearchForcedCaseInsensitive()

isSearchForcedCaseInsensitive()

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

toeknee•9/7/23, 9:06 AM

Can you provide your resource code?

MAFOP•9/7/23, 9:17 AM

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

toeknee•9/7/23, 9:20 AM

sure

toeknee•9/7/23, 9:20 AM

make sure to send the list file too

MAFOP•9/10/23, 8:34 PM

@toeknee should I try to fix this?

toeknee•9/10/23, 8:35 PM

Feel free sorry I am struggling for time at@

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

Similar Threads

Similar Threads

Similar Threads