In our app we have a dynamic list of columns for a table (that can be changed by the user) and want to provide an Export functionality. But since the “raw column header” are technical keys, we want to show a nice “label” instead. This is done using a custom SQL select statement that is loaded predefined from a datasource. (since we can not use valueMappings or other app-json things to dynamically select a subset of columns in the table).
The problem/suspicion: Is it possible that as soon as we use “SELECT i.column AS niceColumnName” (that is, an sql alias), the download options will not work anymore? I see the following error when trying to download something in such a table:
Data Table could not be retrieved: linkId is marked non-null but is null (reported error code: 500)