Filament•14mo ago

table select filter get all records instead of limiting it to relationship

I have a Customer model, which has many Album models, then the Album model belongs to a Stylist model. I make an table widget to display all the albums of that customer, and I create a select filter to filter albums based on the stylist name. Here is the table query:

protected function getTableQuery(): Builder
{
    return $this->record->albums()->getQuery();
}

protected function getTableQuery(): Builder
{
    return $this->record->albums()->getQuery();
}

Here is the filter:

protected function getTableFilters(): array
{
    return [
        SelectFilter::make('stylist')
            ->relationship('stylist', 'name')
            ->preload()
            ->searchable()
            ->native(false),
    ]

protected function getTableFilters(): array
{
    return [
        SelectFilter::make('stylist')
            ->relationship('stylist', 'name')
            ->preload()
            ->searchable()
            ->native(false),
    ]

Them problem is, instead of only get stylists relating to albums of that customer, it returns all stylists. I check debugbar and this is the query the filfer is using:

select * from `users` where `users`.`deleted_at` is null

select * from `users` where `users`.`deleted_at` is null

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

table select filter get all records instead of limiting it to relationship