Filament•2y ago

Is it possible to modify the aggregation column query?

I am currently loading the sum of amount field from transactions relation on my CoinsPack model using the following code. The Transaction has a status field which can be either pending, cancelled and successful and I want the sum of amount column for only successful transactions.

Tables\Columns\TextColumn::make('transactions_sum_amount')
    ->sum('transactions', 'amount')
    ->money('USD')
    ->label('Sales')
    ->placeholder('No sales'),

Tables\Columns\TextColumn::make('transactions_sum_amount')
    ->sum('transactions', 'amount')
    ->money('USD')
    ->label('Sales')
    ->placeholder('No sales'),

5 Replies

PandaOP•2y ago

I've tried to modify the query using the table method in listing page but I guess it has a bug as when added, the entire table disappears (rows and header) and only the pagination row is visible. https://filamentphp.com/docs/3.x/panels/resources/listing-records#customizing-the-table-eloquent-query

Listing records - Panel Builder - Filament