Export Issue with PostgreSQL

[Umar-Farooq-Shafi]

Package

filament/actions

Package Version

v3.2.61

Laravel Version

v10.48.4

Livewire Version

v3.4.9

PHP Version

8.2

Problem description

Export Issue when using PostgreSQL ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions ref link to work with DISTINCT ON in PostgreSQL https://github.com/typeorm/typeorm/issues/4742#issuecomment-783857414

Expected behavior

Export the file

Steps to reproduce

Add the Export button to the filament table with PostgreSQL.

Reproduction repository

https://github.com/Umar-Farooq-Shafi/filament-export-action

Relevant log output

No response

Donate 💰 to fund this issue

• You can donate funding to this issue. We receive the money once the issue is completed & confirmed by you.
• 100% of the funding will be distributed between the Filament core team to run all aspects of the project.
• Thank you in advance for helping us make maintenance sustainable!

[github-actions[bot]]

Hey @Umar-Farooq-Shafi! We're sorry to hear that you've hit this issue. 💛

However, it looks like you forgot to fill in the reproduction repository URL. Can you edit your original post and then we'll look at your issue?

We need a public GitHub repository which contains a Laravel app with the minimal amount of Filament code to reproduce the problem. Please do not link to your actual project, what we need instead is a minimal reproduction in a fresh project without any unnecessary code. This means it doesn't matter if your real project is private / confidential, since we want a link to a separate, isolated reproduction. That would allow us to download it and review your bug much easier, so it can be fixed quicker. Please make sure to include a database seeder with everything we need to set the app up quickly.

[Umar-Farooq-Shafi]

No need to create a reproducible repo.

[github-actions[bot]]

Thank you for providing reproduction steps! Reopening the issue now.