Filtered query in ListRecords page for badges

[AxelvdS]

Package

Infolist builder

Package Version

v3.2.131

How can we help you?

Hi,

I love Filament and have built an app that uses schedules. I have a class ListSchedules that extends ListRecords and uses tabs for filtering of the table. Each tab has a badge with a count to show the records that apply to the tab filter. This all works great. What I cannot work out is how to get the original query from the ScheduleResource table that has other filters already applied. When selecting a tab, the table shows the records filtered using the ScheduleResource filters as well as the ListSchedules Tab filter, but I don't know how I can get the badge count to match the number of records. Below is the getTabs function of ListSchedules.

    public function getTabs(): array
    {   
        return [
            'all' => Tab::make('All schedules')
                ->icon(fn() => $this->activeTab === 'all' ? 'gmdi-double-arrow-r' : null),
            'draft' =>  Tab::make('Draft')
                ->icon(fn() => $this->activeTab === 'draft' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('schedule_status', 'Draft')->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('schedule_status', 'Draft')),
            'chargeable' =>  Tab::make('Chargeable')
                ->icon(fn() => $this->activeTab === 'chargeable' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('chargeable', true)->where('invoiced', false)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('chargeable', true)->where('invoiced', false)),
            'follow_up' =>  Tab::make('Follow up')
                ->icon(fn() => $this->activeTab === 'follow_up' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('schedule_status', 'Follow up', true)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('schedule_status', 'Follow up', true)),
            'on_hold' =>  Tab::make('On Hold')
                ->icon(fn() => $this->activeTab === 'on_hold' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('schedule_status', 'On Hold', true)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('schedule_status', 'On Hold', true)),
            'time_and_materials' =>  Tab::make('T & M')
                ->icon(fn() => $this->activeTab === 'time_and_materials' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('time_and_materials', true)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('time_and_materials', true)),
            'notes_checked' =>  Tab::make('Notes not checked')
                ->icon(fn() => $this->activeTab === 'notes_checked' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('notes_checked', false)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('notes_checked', false)),
            'black_book' =>  Tab::make('Black Book')
                ->icon(fn() => $this->activeTab === 'black_book' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('black_book', true)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('black_book', true)),
            'builders_favours' =>  Tab::make('Builders Favours')
                ->icon(fn() => $this->activeTab === 'builders_favours' ? 'gmdi-double-arrow-r' : null)
                ->badge(function () {
                    return Schedule::query()->where('builders_favours', true)->count();
                })
                ->modifyQueryUsing(fn (Builder $query) => $query->where('builders_favours', true)),
        ];
    }

[AxelvdS]

I finally found the solution: ->badge(fn () => $this->getFilteredTableQuery()->clone()->count())

Some of the filament methods are so hard to find. Is it worth starting to build a filament reference?