Feature Request: Add method to get filtered table query without tab modifications

[andrewdwallo]

Description

Currently, when implementing tab badge counts in List pages, we can either:

1. Show total counts (ignoring active filters)
2. Use getFilteredTableQuery() which includes the current tab's query modifications

This makes it challenging to display accurate badge counts that respect the current table filters while ignoring tab-specific query modifications.

A new method like getFilteredTableQueryWithoutTabModifications() would solve this by returning the filtered query state without applying the active tab's modifications.

Example use case:

public function getTabs(): array
{
    return [
        'all' => Tab::make()->label('All'),
        'unpaid' => Tab::make()
                ->label('Unpaid')
                ->modifyQueryUsing(fn (Builder $query) => $query->unpaid())
                ->badge(fn () => $this->getFilteredTableQueryWithoutTabModifications()->unpaid()->count()),
        'draft' => Tab::make()
                ->label('Draft')
                ->modifyQueryUsing(function (Builder $query) $query->draft())
                ->badge(fn () => $this->getFilteredTableQueryWithoutTabModifications()->draft()->count()),
    ];
}

This would ensure badge counts accurately reflect active filters while maintaining consistent counts across tab switches. This is usually an issue if you have 2 or more tabs with badge counts.

The current workaround involves temporarily nullifying the active tab to get the base filtered query, which causes UI lag due to reactive updates:

protected function getTabCount(callable $modifier): int
{
    $currentTab = $this->activeTab;
    $this->activeTab = null;
    $count = $modifier($this->getFilteredTableQuery());
    $this->activeTab = $currentTab;
    return $count;
}

public function getTabs(): array
{
    return [
        'all' => Tab::make()->label('All'),
        'unpaid' => Tab::make()
                ->label('Unpaid')
                ->modifyQueryUsing(fn ($query) => $query->unpaid())
                ->badge(fn () => $this->getTabCount(
                    fn ($query) => $query->unpaid()->count()
                )),
        'draft' => Tab::make()
                ->label('Draft')
                ->modifyQueryUsing(function (Builder $query) $query->draft())
                ->badge(fn () => $this->getTabCount(
                    fn ($query) => $query->draft()->count()
                )),
    ];
}

[e2d2-dev]

you could add a new relation to the model depending on your scope

public function paidInvoices(): HasMany { return $this->invoices->paid(); }

this returns a valid hasMany relationship which is not limited to anything other than the base relationship

[andrewdwallo]

I'm not sure how this would help..

[andrewdwallo]

Can you show me an example of how that would be applied to the current logic above? Thanks

[e2d2-dev]

ListRecord:
public function getTabs(): array
{
return [
'all' => Tab::make()->label('All'),
'unpaid' => Tab::make()
->label('Unpaid')
->modifyQueryUsing(fn ($query) => $query->unpaid())
->badge(fn () => $$this->record->paidInvoices()->count()
];
}

Model with invoices as relation:
public function invoice(): HasMany
{
return $this->hasMany(Invoice::class);
}

public function paidInvoices(): HasMany
{
return $this->invoices->where('status', 'paid')
}