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•9mo 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

coreOP•9mo ago

this is a json column

Dennis Koch•9mo ago

Is there any difference depending search? I am not sure.

coreOP•9mo 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•9mo ago

Me same how can you fix it

coreOP•9mo 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•9mo ago

Any one try the filament tree with laravel filament v3 for some advice?

Dennis Koch•9mo ago

How is Filament Tree related to this thread?

engmgemy•9mo ago

Iam sorry is this not related here iam not have experience sorry

engmgemy•9mo ago

Is any usage of this integrations with filament https://spatie.be/docs/laravel-event-sourcing/v7/introduction

Introduction | laravel-event-sourcing

laravel-event-sourcing

Gaming

Programming

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