Filament•16mo 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•16mo ago

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

RobinDevOP•16mo ago

Then it does this

RobinDevOP•16mo ago

Dennis Koch•16mo ago

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

aj10144•16mo ago

Shouldn't it be orderProducts.name ?

BlackShadow•16mo ago

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

Getting started - Table Builder - Filament

BlackShadow•16mo 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