F
Filament•5d ago
Davide Cariola

Filter for calculated field

Hello everyone! In a filament table I have a field called TTF (Topical Trust Flow) which has a dynamic numeric value depending on the topic chosen by the user. I would like to perform a filter on this value, but I need the filter not to be "custom" in the Livewire component page but rather to be a filament filter. The point is that this calculated field is not saved in the database and so I would not know where to retrieve this information with the classic query method. Thank you very much for any help you can give me. Attached is the code for the column.
No description
5 Replies
awcodes
awcodes•5d ago
Currently, because filters are tied directly to eloquent, I think the only way to do this would be with a virtual column on the table.
Davide Cariola
Davide Cariola•4d ago
Hi, thank you for the response! I was wandering about an SQL view. When you talk about a virtual column you intend in filament or in the DB?
Jany
Jany•4d ago
You can also adjust main query to calculate that column, or have virtual sql column or sql view, or havinng job to calculate that column from time to time
Dennis Koch
Dennis Koch•4d ago
Virtual Columns are a SQL concept.
Davide Cariola
Davide Cariola•2d ago
Thanks everyone. Tomorrow I'll work on it and let you know!
Want results from more Discord servers?
Add your server
More Posts
Multiple databases integration.Hello everyone, I am making an admin panel for many suppliers and each supplier has its own shcema aState of multiple toggle buttonsI have multiple dynamically generated toggle buttons, I need to get the state of all of the toggle bCheckboxlist: Options can't be checked separatelyFor some reason, if I check one option all options get checked and vise versa. What am I missing? IvalidationI'm getting to know laravel filament, and I have a problem when sending the form to create it with tCheckboxlist set all true by defaultIs there a way to set all options to true by default? Without the need to specify the options one byWhy is my $record->save(); not workingShould I expect one of these to save the current record? ```Action::make('Run Campaign') ->actHow do I change the font size in Filament forms?I installed Filament Forms to be used within Livewire. I found that the text size of all of the formBackend Form validation example?I'm using Filament Forms package in a Livewire component. Does anyone have a working example of how How do I open a Filament Form in a Modal?I just installed Filament Forms to my Larvel 11 project. I want to open a Filament form in a Modal wValidation messages not working on custom page?Hi, I have custom page ``` class Company extends Page implements HasForms { use InteractsWithFor