F
Filament•4mo 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 Koch•4mo 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
core•3mo ago
this is a json column
Dennis Koch
Dennis Koch•3mo ago
Is there any difference depending search? I am not sure.
core
core•3mo 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
engmgemy•3mo ago
Me same how can you fix it
core
core•3mo 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
engmgemy•3mo ago
Any one try the filament tree with laravel filament v3 for some advice?
Dennis Koch
Dennis Koch•3mo ago
How is Filament Tree related to this thread?
engmgemy
engmgemy•3mo ago
Iam sorry is this not related here iam not have experience sorry
engmgemy
engmgemy•3mo 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
Want results from more Discord servers?
Add your server
More Posts
Linking javascript file to componentWhat is the best way to link a javascript file to a component? I want to be able to run functions ofHow do form fields with relationships work?I'm using the spatie roles and permissions on my Filament panel, and would like to write some tests Save Action in a separate filehello , can I save the actions in a separate file to use it in multiple places and avoid code duplicrelations table get datai have 2 selections supplier and brand. in supplier table i have brand_id column i want when i choosEdit action in getHeaderActionsI used to be able to simply do this on Resource view page (or any other Resource page): ```php pExport Action -No modal for column selectionHow could we prevent showing the modal with column selections when exporting csv/excel data?Can we modify SpatieTags to prevent dynamically adding new tags?This is about SpatieTags plugin (https://filamentphp.com/plugins/filament-spatie-tags) I have createHow to add actions to custom header viewTrait method Filament\Actions\Concerns\InteractsWithActions::afterActionCalled has not been applied SpatieMediaLibraryFileUpload inside action how to attach to new modelI have an Order Resource in infolist i have an action that creates a payment record attached to curMethod Filament\Panel::assets does not exist.I'm on Filament 3.1 Trying to register assets for a panel. ```php public function panel(Panel $pan