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
typeorm/typeorm#4742 (comment)

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

[github-actions]

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]

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