Filament•3y ago•

6 replies

Is it possible to modify the aggregation column query?

I am currently loading the sum of

amount

amount

field from

transactions

transactions

relation on my

CoinsPack

CoinsPack

model using the following code. The

Transaction

Transaction

has a

status

status

field which can be either

pending

pending

cancelled

cancelled

and

successful

successful

and I want the sum of

amount

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'),

Filament•3y ago•

6 replies

Panda

Is it possible to modify the aggregation column query?

I am currently loading the sum of

amount

amount

field from

transactions

transactions

relation on my

CoinsPack

CoinsPack

model using the following code. The

Transaction

Transaction

has a

status

status

field which can be either

pending

pending

cancelled

cancelled

and

successful

successful

and I want the sum of

amount

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'),

Is it possible to modify the aggregation column query?

Similar Threads

Is it possible to modify the aggregation column query?

Similar Threads

Similar Threads

Similar Threads