F
Filament•2d ago
Hung Thai

Form Select relationship with custom search

hi. I want to implement the custom search to the form select component. How can I archive this? I've tried to use the component relationship() with modifyQueryUsing: ($query, $search) callback function but no luck. Context: for example, I have a product, which belongs to an order, and product also belongs to an category. I want to make a select field inside create/edit an order resource, with the functional search with product code, product name, and category's name for example.
18 Replies
toeknee
toeknee•2d ago
Hung Thai
Hung ThaiOP•2d ago
unfortunately, this did not work with the relationship defined...
toeknee
toeknee•2d ago
Ok actually makes sense, let me think Got it, pass in $get to the modifyQueryUsing 
modifyQueryUsing: fn ($state, $search, $query, $get) => $query->where('product_code', $get('product_code')))
modifyQueryUsing: fn ($state, $search, $query, $get) => $query->where('product_code', $get('product_code')))
Hung Thai
Hung ThaiOP•2d ago
Let me try this. Thank you for your time. And btw, do you know how to create a new option from the Form's Select fields without any relationship define to the component? Whenever I want to add new option, the app thrown me the error 'Call to a member function isRelation() on null'.
toeknee
toeknee•2d ago
What is your relationship method I can't see how that would happen tbh.... creating an option just creates it directly
Hung Thai
Hung ThaiOP•2d ago
this is not what I'm looking for. I wantted to perform the search from within the Select component. Like Forms\Components\Select::make('product')->relationship('orderProducts', 'product_name')->searchable(true) and then perform the search (when the user input the search field) on the Product - Category relationship
toeknee
toeknee•2d ago
Possibly you haven't back created the relationship on the relating model you can pass in a function to searchable() and modify the query there i am sure.
Hung Thai
Hung ThaiOP•2d ago
I've tried to pass in the $query to the searchable(), but it throw me the error, it didn't accept the $search param
toeknee
toeknee•2d ago
But if you are searching the options.... wouldn't you want the select to be query filtered anyway? Since that's the searchable Just condition the query to not filter when no search is there?
Hung Thai
Hung ThaiOP•2d ago
the searchable callback didn't accept the $search param, so I can't get the user input for search there An attempt was made to evaluate a closure for [Filament\Forms\Components\Select], but [$query] was unresolvable.
toeknee
toeknee•2d ago
I mean in the modifyQueryUsing 
modifyQueryUsing: function ($state, $search, $query, $get) {
  if(!empty($search)) {
   $query->where('product_code', $get('product_code')));
  }
  
  return $query;
}
modifyQueryUsing: function ($state, $search, $query, $get) {
  if(!empty($search)) {
   $query->where('product_code', $get('product_code')));
  }
  
  return $query;
}
Hung Thai
Hung ThaiOP•2d ago
the modifyQueryUsing accept the $query and $search param. But when i test it, it doesn't accept the $search. like: if ($search) { dd($search); } to check if the search was accepted, but it didn't run.
toeknee
toeknee•2d ago
Just remove the relationship then, and have it as a select with the custom query for the options like you want.
Hung Thai
Hung ThaiOP•2d ago
but then I can not perform the ->createOptionForm() / -editOptionForm() on the Select component 🥲
toeknee
toeknee•2d ago
You can define a PrefixAction that does that? It's a bit more work but would work.
toeknee
toeknee•2d ago
toeknee
toeknee•2d ago
Set the create action to be visibleOn('create') and edit one to be visibleOn('edit')
Hung Thai
Hung ThaiOP•2d ago
yeah, guess I have to customize this to my need then. Thank you!

Did you find this page helpful?