Export with aggregating relationship (sum)

✅ SolvedPanels5️⃣v5

On table I display like below which is working fine
⁨⁨

TextColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight')

TextColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight')

⁩⁩

But when I try to export, I got error ⁨⁨

Undefined array key "items_sum_actual_weight_value"

Undefined array key "items_sum_actual_weight_value"

⁩⁩, below is how I put in exporter
⁨⁨

ExportColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight'),

ExportColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight'),

⁩⁩

And I also have this modify query like this comment Exporting a sorted sum column with ExportAction

⁨⁨

public static function modifyQuery(Builder $query): Builder
{
    return $query
        ->withSum('items', 'actual_weight_value')
        ->withCount('items');
}

public static function modifyQuery(Builder $query): Builder
{
    return $query
        ->withSum('items', 'actual_weight_value')
        ->withCount('items');
}

⁩⁩

So, what should be the problem here?

Solution

welp, silly me.. I forgot to restart queue:work after changing something

Jump to solution

Filament•6d ago•

4 replies

Export with aggregating relationship (sum)

✅ SolvedPanels5️⃣v5

On table I display like below which is working fine
⁨⁨

TextColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight')

TextColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight')

⁩⁩

But when I try to export, I got error ⁨⁨

Undefined array key "items_sum_actual_weight_value"

Undefined array key "items_sum_actual_weight_value"

⁩⁩, below is how I put in exporter
⁨⁨

ExportColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight'),

ExportColumn::make('items_sum_actual_weight_value')
    ->sum('items', 'actual_weight_value')
    ->label('Total Weight'),

⁩⁩

And I also have this modify query like this comment Exporting a sorted sum column with ExportAction

⁨⁨

public static function modifyQuery(Builder $query): Builder
{
    return $query
        ->withSum('items', 'actual_weight_value')
        ->withCount('items');
}

public static function modifyQuery(Builder $query): Builder
{
    return $query
        ->withSum('items', 'actual_weight_value')
        ->withCount('items');
}

⁩⁩

So, what should be the problem here?

Solution

welp, silly me.. I forgot to restart queue:work after changing something

Jump to solution

Export with aggregating relationship (sum)

Similar Threads

Export with aggregating relationship (sum)

Similar Threads

Similar Threads

Similar Threads