CSV Export from table does not take column selection into account - also PKs are not resolved in the Export

[pgrill79]

I can export an table to a CSV. A filter is taken into account, but

• the selected columns are not (all columns are exported)
• also PKs are not resolved in the Export

Table (with Filter an selected columns):

Export:

[aeberhart]

we are using the default react admin export feature https://marmelab.com/react-admin/List.html#exporter

guess taking the projected columns into account would be possible (asked a question in the RA discord)

not sure about the key issue, since there might be different keys that resolve to the same key (e.g. many persons might be called fisher)

the same applies for the display of dates, images, etc. There are always two underlying use cases:

1. get the underlying data in a "clean" format
2. get the data from a display / print angle

[aeberhart]

opened an issue with react admin: https://github.com/marmelab/react-admin/issues/9986

[aeberhart]

We decided to stick with the default logic offered by the underlying framework. There are simply too many export options which make it quite complex.

As a workaround, you can create a query that resolves the pks and formats the other options as needed