Filament•2y ago

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•2y ago

Did you try it with order.orderProducts.name already?

RobinDevOP•2y ago

Then it does this

RobinDevOP•2y ago

Dennis Koch•2y ago

Okay. Thought it might be supported out of the box 😅

aj10144•2y ago

Shouldn't it be orderProducts.name ?

BlackShadow•2y ago

https://filamentphp.com/docs/3.x/tables/columns/getting-started#searching

Getting started - Table Builder - Filament

BlackShadow•2y 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?

Gaming

Programming

Search in relationship from main model

Did you find this page helpful?