Export CSV does not export Lens fields

[morrislaptop]

• Laravel Version: 9.x
• Nova Version: 4.x
• PHP Version: 8.x
• Database Driver & Version: Postgres 12
• Operating System and Version: Mac 12.3
• Browser type and version: Chrome 101
• Reproduction Repository: ...

Description:

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

[crynobone]

The Export CSV uses database fields, you should add withFormat()

[morrislaptop]

@crynobone What about a Lens with a group by?

[morrislaptop]

It works with Selected Resources = all, but from the looks of it the ExportCsv class goes back down to the Index Query of the underlying resource if some resources are selected? Seems ExportCsv doesn't support Lens and is a bug?

[moisessepulveda]

i have the same issue

[benedict-w]

I'm also exporting a Lens with a GROUP BY query, and it only exports records when all resources are selected (also Laravel 9.x and Nova 4.x)

[RenoLooijmans]

I'm experiencing the same issue.

[kazak71]

I have the same problem

[crynobone]

Limitation with Group By: See #5020