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

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

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

Filament•3y ago•

6 replies

MAF

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

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

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

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Filament

A powerful open-source UI framework for Laravel • Build and ship apps & admin panels fast with Livewire

20,181 Members

Join

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

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

Continue the conversation

Filament

Continue the conversation

Filament

Similar Threads