Help Needed with Multiple SelectFilter Usage in advanced-tables-docs

[kishan-pinetco]

Package

Table builder

Package Version

v3.3.8

How can we help you?

I’m currently working with this package advanced-tables-docs and facing an issue with SelectFilter. I want to have two filters like these:

SelectFilter::make('products.name')
    ->label('Products')
    ->translateLabel()
    ->relationship('products', 'name', modifyQueryUsing: fn () => Product::where('company_id', auth()->user()->company_id)->whereNull('deleted_at'))
    ->multiple()
    ->preload()
    ->searchable(),

SelectFilter::make('products.name')
    ->label('Deleted products')
    ->translateLabel()
    ->relationship('products', 'name', modifyQueryUsing: fn () => Product::withTrashed()->where('company_id', auth()->user()->company_id)->whereNotNull('deleted_at'))
    ->multiple()
    ->preload()
    ->searchable(),

**Order.php(Model)**

public function products(): HasManyThrough
{
    return $this->hasManyThrough(Product::class, OrderItem::class, 'order_id', 'id', 'id', 'product_id')->withTrashed();
}

But only the second filter is showing, or if I change the name, only the first shows.

Also I've filter like:

SelectFilter::make('employee.name')
                            ->label('Employee')
                            ->translateLabel()
                            ->relationship('employee', 'name')
                            ->preload()
                            ->multiple()
                            ->searchable(),
                            

I've added tabs inside ListOrders.php

public function getTabs(): array
    {
        return [
            'machine' => Tab::make('machine')->label(__('Machine'))
                ->query(fn (Builder $query) => $query->whereNull('employee_id')),
            'app' => Tab::make('app')->label(__('Application'))
                ->query(fn (Builder $query) => $query->whereNotNull('employee_id')),
        ];
    }

I want to show this filter if the tab is app.

Could you please help me understand why this is happening and how to fix it? Any guidance or suggestions would be highly appreciated.

Thanks in advance for your support!

[archilex]

What you are seeing isn't related to Advanced Tables. Filters (as well as other components) need to have unique names and if you have the same naming, the last one will be used.

Since what you want to do is to have a slightly different relationship query depending on which tab you have (tabs BTW are a native Filament feature, presetViews are the plugin feature), you can pass $livewire to the closure and then reference that in the query and modify the query depending on which tab is active. I believe it is $livewire->activeTab.

[kishan-pinetco]

@archilex Thanks for the reply.

I know that the name of the filter is the issue. But as I said I've already tried with the different name of both filter but only first filter is showing on the panel.

I've made changes like:

SelectFilter::make('products.name')
  ->label('Products')
  ->translateLabel()
  ->relationship('products', 'name', modifyQueryUsing: fn () => Product::where('company_id', auth()->user()->company_id)->whereNull('deleted_at'))
  ->multiple()
  ->preload()
  ->searchable(),
SelectFilter::make('deletedProducts.name')
  ->label('Deleted products')
  ->translateLabel()
  ->relationship('deletedProducts', 'name', modifyQueryUsing: fn () => Product::withTrashed()->where('company_id', auth()->user()->company_id)->whereNotNull('deleted_at'))
  ->multiple()
  ->preload()
  ->searchable(),

Order.php (Model)

public function products(): HasManyThrough
{
    return $this->hasManyThrough(Product::class, OrderItem::class, 'order_id', 'id', 'id', 'product_id')->withTrashed();
}

public function deletedProducts(): HasManyThrough
{
    return $this->hasManyThrough(Product::class, OrderItem::class, 'order_id', 'id', 'id', 'product_id')->withTrashed();
}

It's showing only first filter. But if I use second filter outside below array then it's working fine.

AdvancedFilter::make()
  ->includeColumns()
  ->filters([

Can you please tell me what can be issue?

[archilex]

Are you importing AdvancedTables' SelectFilter? If so, that would explain why you aren't seeing the second filter. The filters that come with the plugin (TextFilter, NumericFilter, etc) are "column filters" and require the name of the filter to match one of the resource column names otherwise they won't appear.

One option would be to import both. Use the plugin's SelectFilter for "products.name" (assuming that column exists in your table) and import Filament's as FilamentSelectFilter or something for the other one.

That will give you different UI for each one though.

Or you could modify the query like I had suggested before and only use one filter.

Or just use Filament's SelectFilter so the UI is the same for both filters.

Hope that helps!