ExportAction not working with custom query

[zeeshantariq08]

Package

Table builder

Package Version

v3.0.0

How can we help you?

`<?php

namespace App\Filament\Widgets;

use AlperenErsoy\FilamentExport\Actions\FilamentExportBulkAction;
use App\Filament\Exports\AnswerExporter;
use App\Models\Answer;
use App\Models\FathomStatsVisit;
use Filament\Actions\Exports\Enums\ExportFormat;
use Filament\Tables;
use Filament\Tables\Table;
use Filament\Widgets\TableWidget as BaseWidget;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\Relation;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Livewire\Attributes\On;

class AnswerReport extends BaseWidget
{
protected static bool $isLazy = false;
public ?string $startDate = null;
public ?string $endDate = null;
protected int|string|array $columnSpan = 'full';

#[On('updateFromDate')]
public function updateFromDate(?string $from, ?string $to): void
{
    $this->startDate = $from;
    $this->endDate = $to;
    $this->resetTable();
}

public function table(Table $table): Table
{
    return $table
        ->paginated()
        ->query(
            $this->getTableQuery()
        )
        ->columns([
            Tables\Columns\TextColumn::make('user_id')
                ->label('Homeowner ID'),
            Tables\Columns\TextColumn::make('homeowner_name')
                ->label('Homeowner Name'),
            Tables\Columns\TextColumn::make('question')
                ->formatStateUsing(function ($state) {
                    $decoded = json_decode($state, true);
                    return is_array($decoded) ? reset($decoded) : $state;
                }),


            Tables\Columns\TextColumn::make('answers')
                ->formatStateUsing(function ($state, $record) {
                    $answers = collect(json_decode("[" . str_replace("}, {", "},{", $record->answers) . "]", true))
                        ->pluck('en')
                        ->implode(', ');

                    return $answers;


                }),
        ])->headerActions([
            Tables\Actions\ExportAction::make('export')
            ->exporter(AnswerExporter::class)
            ->formats([
                ExportFormat::Csv,
            ])
            ]);

}


public function getTableQuery(): Builder|Relation|null
{
    $query = Answer::query()
        ->select(
            DB::raw('ROW_NUMBER() OVER () as id'), // Generate ID dynamically
            'questions.text as question',
            'answers.user_id',
            DB::raw("CONCAT(members.first_name, ' ', members.last_name) as homeowner_name"),
            DB::raw("GROUP_CONCAT(DISTINCT COALESCE(options.text, JSON_UNQUOTE(JSON_EXTRACT(answers.response, '$.value'))) SEPARATOR ', ') as answers")
        )
        ->join('questions', 'answers.question_id', '=', 'questions.id')
        ->join('members', 'answers.user_id', '=', 'members.id') // Ensure 'members' is used instead of 'customers'
        ->leftJoin('options', 'answers.option_id', '=', 'options.id')
        ->groupBy('questions.text', 'answers.user_id', 'members.first_name', 'members.last_name')
        ->orderBy('questions.text', 'asc');
    if (!empty($this->startDate) && !empty($this->endDate)) {
        $query->whereBetween('answers.created_at', [$this->startDate, $this->endDate]);
    }

    return $query;
}

public function getTableRecordKey(Model $record): string
{
    return $record->id;
}

}
`
it is giving this error
Export completed
Your answer export has completed and 0 rows exported. 1 row failed to export.
@leandrocfe any idea?