Filament•14mo ago

search id column in table

postgress sql: SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1: ...e from "blg_categories" where "type_id" = $1 and (lower(id):... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. SELECT count(*) AS aggregate FROM "blg_categories" WHERE "type_id" = -9009 AND ( lower(id):: text LIKE % 1 % OR lower(title):: text LIKE % 1 % OR lower(slug):: text LIKE % 1 % )

Solution:

That's a Postgres specific issue, being triggered by a workaround for another Postgres specific issue (case insensitive searching). Try turning that off like this: ```php...

Jump to solution

2 Replies

Solution

cheesegrits•14mo ago

That's a Postgres specific issue, being triggered by a workaround for another Postgres specific issue (case insensitive searching). Try turning that off like this:

TextColumn::make('id')
  ->searchable()
  ->forceSearchCaseInsensitive(false),

TextColumn::make('id')
  ->searchable()
  ->forceSearchCaseInsensitive(false),

MostafaOP•14mo ago

@Hugh Messenger Thank you for your kindness. fixed.🙌 🌻

Gaming

Programming

search id column in table