F
Filament11mo ago
core

Search by lowercase in Table not working with Spatie Translate json column

How can I configure the TableSearchQuery to be case-insensitve in a Filament Resource?
Tables\Columns\TextColumn::make('name')->searchable(),
Tables\Columns\TextColumn::make('name')->searchable(),
10 Replies
Dennis Koch
Dennis Koch11mo ago
I think that depends on your Database collation and not on Filament. You need a collation like UTF8_GENERAL_CI which is Case Insensitive
core
coreOP10mo ago
this is a json column
Dennis Koch
Dennis Koch10mo ago
Is there any difference depending search? I am not sure.
core
coreOP10mo ago
apparently if the column format is json seems like filament treats it as case sensitive in table column search, which function overrides the table search query?
engmgemy
engmgemy10mo ago
Me same how can you fix it
core
coreOP10mo ago
Apparently changing the field type to varchar(255) in mysql solves it , the package still works, question is the performance issues on querying the json inside a varchar as opposed to a pre structured json column
engmgemy
engmgemy10mo ago
Any one try the filament tree with laravel filament v3 for some advice?
Dennis Koch
Dennis Koch10mo ago
How is Filament Tree related to this thread?
engmgemy
engmgemy10mo ago
Iam sorry is this not related here iam not have experience sorry
engmgemy
engmgemy10mo ago
Is any usage of this integrations with filament https://spatie.be/docs/laravel-event-sourcing/v7/introduction

Did you find this page helpful?