F
Filament•12mo ago
RobinDev

Search in relationship from main model

I have a order resource, and the order model has orderProducts, hasMany, i want to be able to search in the order.orderProducts.name variable in the table of the order resource, how can i achieve this?
7 Replies
Dennis Koch
Dennis Koch•12mo ago
Did you try it with order.orderProducts.name already?
RobinDev
RobinDev•12mo ago
Then it does this
RobinDev
RobinDev•12mo ago
Dennis Koch
Dennis Koch•12mo ago
Okay. Thought it might be supported out of the box 😅
aj10144
aj10144•12mo ago
Shouldn't it be orderProducts.name ?
BlackShadow
BlackShadow•12mo ago
BlackShadow
BlackShadow•12mo ago
You could custimize the query: 
TextColumn::make('full_name')
    ->searchable(query: function (Builder $query, string $search): Builder {
        return $query
            ->where('first_name', 'like', "%{$search}%")
            ->where('last_name', 'like', "%{$search}%");
    })
TextColumn::make('full_name')
    ->searchable(query: function (Builder $query, string $search): Builder {
        return $query
            ->where('first_name', 'like', "%{$search}%")
            ->where('last_name', 'like', "%{$search}%");
    })
make it work like that?
Want results from more Discord servers?
Add your server
More Posts
Show a warning before leaving page when you have filled in a form (save/discard changes)I have a large form where the save button is far down, sometimes people forget to press it and leaveIs it possible to get form from resource and add it to createOptionForm?As the title says, I don't like having to repeat the content of the form in a section and in any othHow would you support record versioning?I have a few ideas how to support this, but wondering if anyone is aware of a plugin or a way to do Is there a way to edit the entire filament interface to suit the project?Is there a way to edit the entire filament interface to suit the project?use two from and tablehi iwonder how i can include two form and table from 2 diffrent model inside one resourceWhy are the roles not being translated?im not using admin panel, only installed forms & tables packages ```php Select::make('roles') -How to show tables data ONLY when there's a filter?How to show tables data ONLY when there's a filter?Can we customize filament's form layout and custom view with "designed" elements?I'm thinking to create a form page like this one... I don't think we can achieve this only by using Design question: multiple panels?So I'm new to filament and trying to wrap my head around the best way to use it. I'm designing a datAction Modal - SlideOverHow to set it on the left instead of the default position of the slide over modal?