Exporting a dynamic column that's done using getStateUsing

[jimiero]

Hello,

On my FilamentPHP table, i have some dynamic columns build like:

$columns[] = TextColumn::make('total_user')
            ->label('Total')
            ->alignCenter()
            ->getStateUsing(function ($record, Table $table) use ($total_user) {
                $total = 0; // Initialize total
                foreach ($table->getColumns() as $column) {
                    /** @var TextColumn  $column */
                    $columnName = $column->getName();

                    // Check if the column name starts with 'day_'
                    if (strpos($columnName, 'day_') === 0) {
                        // Get the state of the current column (value)
                        $state = $column->getState();
                        // Add the state to the total if it's numeric
                        if (is_numeric($state)) {
                            $total += $state;
                        }
                    }
                }

                return $total;
            });

@pxlrbt

When I browse the table using filamentphp all good, that column state returns the correct value, but in the export it comes with value 0 any idea what it may be wrong?

@

[pxlrbt]

Hey,
I'm trying to also apply the ->getStateUsing() callbacks, but it's hard to 100% replicate the behaviour of the table. I guess $column->getState() might not be set or $table not injected properly.

[jimiero]

I even tried with $this->table->getColumns, which works in FilamentPHP and still in export that dynamic column gets value 0

[pxlrbt]

But did you try debugging the callback during export? As I said: The excel plugin doesn't use the exact same objects as Filament. It tried to recreate them so things are not always 100% accurate.