F
Filament•10mo ago
H.Bilbao

Show only table options in the filter

I have a table where I have modified the getEloquentQuery and in the active filters I want to show only the options that I show in the table. Example, in the customers table I can have options that I am not showing in the order resource, how can I only show the options displayed in the table?
4 Replies
toeknee
toeknee•10mo ago
You would need to look to get the table query and use that within the filters query
H.Bilbao
H.Bilbao•10mo ago
Thank you for your response, but I don't see how to do it. Now I only have this: 
->relationship('customer', 'name')
->relationship('customer', 'name')
I understand that you mean adding modifyQueryUsing?
toeknee
toeknee•10mo ago
see: https://filamentphp.com/docs/2.x/tables/filters#relationship-select-filters Notice how you can modify the query? So you can use the same method
Filters - Table Builder - Filament
H.Bilbao
H.Bilbao•9mo ago
Could this be the best way to do it? 
->relationship('customer', 'name', fn (Builder $query) => $query->whereIn('id', TicketResource::getEloquentQuery()->pluck('customer_id')))
->relationship('customer', 'name', fn (Builder $query) => $query->whereIn('id', TicketResource::getEloquentQuery()->pluck('customer_id')))
Want results from more Discord servers?
Add your server
More Posts
form input default value not passedHere is my code Select::make('site') ->relationship(name: 'site', titleAttributeneed or not relation manager to display data in a custom pageHello, I've created a custom page but I can't make a ship relationship on my section. I get an errorThe email has already been taken.when I want to edit the user , the email field gives me this error : *The email has already been tacreateOptionForm does not return the correct queryHi, I am tying to create a createOptionForm. But for some reason it is ignoring all of the fields IPossible to replace dashboard view?Is it possible to replace the dashboard view? I followed the instructions in the docs for customizinDynamic WizardI'm currently working on a project where I'm using the Wizard component in Filament. I have a table Not able to replace dashboardAttempting to replace the standard dashboard with my own, and it's not working. I've followed the doWizard Step 2 being skipped in Modal DialogHas anyone else experienced a situation where step 2 (and only step 2!) is always skipped in a Wizarclickable widget with filtercurrently I am in **TeamResource** here is the widget where i have **2 projects** if i click this wiinfolist tabs ->persistTabInQueryString()https://github.com/filamentphp/filament/issues/7803 has anyone come up with a solution for this? it