Export - Order by using root model and fails

[MrYamous]

Livewire PowerGrid version

6.3.3

Livewire version

3.5.1

Laravel version

11.40.18

Which PHP version are you using?

PHP 8.2

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

No

What is the problem?

I have a Table, with some datas from 2 tables
When i order columns from a joined table in the UI, it works fine
When i export the table, with data ordered, a new SQL request is done but with order_by applied on root model and not on joined table

Code snippets

This is request for the datasource (with edited table name) :

select lieu.*, CONCAT(user.nom, " ", user.prenom) as nom_complet from lieuinner jointablename.usersasuseronlieu.num_agent=user.nameanduser.deleted_atis null wherelieu.libellein ('domicile', 'autre-lieu-prive') order bynom_complet asc limit 25 offset 0

This is request for the export :

select lieu.*, CONCAT(user.nom, " ", user.prenom) as nom_complet from lieuinner jointablename.usersasuseronlieu.num_agent=user.nameanduser.deleted_atis null wherelieu.libellein (domicile, autre-lieu-prive) order bylieu.nom_complet asc

Note the difference for order by

And the error :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lieu.nom_complet' in 'order clause'

How do you expect it to work?

Datasource and export should apply order_by the same way

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.

[MrYamous]

After some investigations, it looks like a bit more sneaky.

The problem is maybe more about the concat on joined table
If selected as nom_complet, I have the issue described with order_by

Then i tried to select as user.nom_complet but I was not able anymore to display the data in my table

I will take time to provide a repository to reproduce this issue

[MrYamous]

Bug reproduced here : https://github.com/MrYamous/powergrid-livewire-bug-reproducer
Based on demo repo, i've edited DatasourceJoinTable with a selectRaw and a concat and the export cannot be done if data is sorted

[Daryl-Gregory]

I am also having this problem -- datasource has joins, sortField uses field on joined table, table displays fine. On export to CSV, however, order by is issued on field in root model, not on field in joined table, and I get the same error as above.

[Daryl-Gregory]

Meant to say: Powergrid 6.7.5, livewire 3.7.3, PHP 8.5.3.

If I remove public string $sortField it works.