search

Rothamsted-Ecoinformatics / eRAcuration

Laravel interface for the curators of eRA database and Web sites.
0 stars 0 forks source link

Livewire Datatables do not export in some cases #10

Closed nathcast closed 1 year ago

nathcast commented 2 years ago

When the data has fields from another table then the sql is badly formulated and it does not export.

Is it a problem with my code or with datatable and sqlsrv??

nathcast commented 2 years ago

I have looked on GitHub for the datatables tool and many people have issues with the export function when using relations since the upgrade to Laravel 9. I am monitoring the tool. Meanwhile, a work around is to build views in sqlsrv and use the view to display exportable information. That will be for eRAdata.

nathcast commented 1 year ago

The export feature for complex tables workd on an explicit Builder function, not on the eloquent model. So when I want to have a table that has relation, use a query builder.