Filament•3mo ago

Filament Table tab

I'm trying to apply a condition on the Filament table tab so that when is_archived = 1, it should display in the 'Archived' tab. However, it's not working in my case. I've attached the code for your reference.

<?php
  public function getTabs(): array
    {
        return [
            'new' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->whereNull('magento_id')
                    ->where('is_enabled', false)
                    ->where('is_archived', false)->orderBy('created_at', 'desc')),
            'on_site' => Tab::make()
                ->label('On Site')
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_enabled', true)
                    ->where('is_archived', false)),
            'archived' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_archived', true)),
        ];
    }?>

<?php
  public function getTabs(): array
    {
        return [
            'new' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->whereNull('magento_id')
                    ->where('is_enabled', false)
                    ->where('is_archived', false)->orderBy('created_at', 'desc')),
            'on_site' => Tab::make()
                ->label('On Site')
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_enabled', true)
                    ->where('is_archived', false)),
            'archived' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_archived', true)),
        ];
    }?>

ListProducts.php

19 Replies

bwurtz999•3mo ago

I'm not sure why your query isn't working, but there is a Filament plugin that can handle all of this for you

bwurtz999•3mo ago

https://filamentphp.com/plugins/okeonline-archivable

Filament

Archivable by OKE Online - Filament

This plugin allows you to archive, unarchive, and filter archived records in your application.

Sourabh•3mo ago

Thank you for your prompt response but I want to use filter as a table tab. Hope anyone can give some solution.

LeandroFerreira•3mo ago

the issue happens when you try to search something? I didn't understand the issue..

Sourabh•3mo ago

No, I am not searching anything, I am just clicking on the Archived tab. And for that below code executes (Just refer the 'archived' key):

<?php
  public function getTabs(): array
    {
        return [
            'new' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->whereNull('magento_id')
                    ->where('is_enabled', false)
                    ->where('is_archived', false)->orderBy('created_at', 'desc')),
            'on_site' => Tab::make()
                ->label('On Site')
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_enabled', true)
                    ->where('is_archived', false)),
            'archived' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_archived', true)),
        ];
    }?>

<?php
  public function getTabs(): array
    {
        return [
            'new' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->whereNull('magento_id')
                    ->where('is_enabled', false)
                    ->where('is_archived', false)->orderBy('created_at', 'desc')),
            'on_site' => Tab::make()
                ->label('On Site')
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_enabled', true)
                    ->where('is_archived', false)),
            'archived' => Tab::make()
                ->modifyQueryUsing(fn (Builder $query) => $query
                    ->where('is_archived', true)),
        ];
    }?>