ExportAsCsv not eagerLoading withQuery

[HugoHeneault]

• Laravel Version: 10.10
• Nova Version: 4.32.11
• PHP Version: 8.1
• Database Driver & Version: Mysql 8.x
• Operating System and Version: Ubuntu 22.04 LTS
• Browser type and version: NA
• Reproduction Repository: NA (yet)

Description:

I want to export models with eager loading but using with() isn't enough, I have to load() each model's relations to be able to download.

             ExportAsCsv::make()
                ->withQuery(function (Builder $query, $fields) {
                   // This has no effect
                    $query = $query->with(['user', 'evalForms', 'evaluations', 'evaluations.evalForm', 'evaluations.criterion', 'channel']);

                    return $query;
                })
                ->withFormat(function (Model $model) {
                   // if I uncomment this, it works, but it'll make thousands of eager loading (one per model)
                   //$model->load(['user', 'evalForms', 'evaluations', 'evaluations.evalForm', 'evaluations.criterion', 'channel']);

                    $avgScore = match ($model->average_score->scoreStatus) {
                        InteractionAverageScoreStatus::AVAILABLE => round($model->average_score->score),
                        InteractionAverageScoreStatus::PENDING => '×', 
                        InteractionAverageScoreStatus::AWAITING => 'Awaiting' 
                    };

                    return [
                        'ID' => $model->id,
                        'Duration' => $model->duration,
                        'Date' => $model->created_at->format('Y-m-d H:i:s'),
                        'Agent' => $model->user->name,
                        'Channel' => $model->channel->name,
                        'Score' => $avgScore,
                        'Eval Forms' => $model->evalForms->pluck('title')->join(', '),
                    ];

Detailed steps to reproduce the issue on a fresh Nova installation:

1. Enable preventLazyLoading
2. Add relations to a model and resource
3. Add an ExportAsCsv action
4. Set the withQuery and add a with() inside of it
5. Without using load() withFormat in it will fail when you download

[crynobone]

Released with Laravel Nova 5.0.0

Feel free to open up a new issue if you're still experiencing this problem on the latest version.