search

moodleou / moodle-report_customsql

A Moodle report plugin that lets you easily create simple reports that can be expressed as a single SQL query
46 stars 100 forks source link

Column Names #136

Closed rmeske closed 1 year ago

rmeske commented 1 year ago

When attempting to output column labels that are compatible with a system that is then importing the output, I am finding that the strings being used are being modified. For example, 'CD_VAL_CD' outputs as 'cd val cd'.

Since CONCAT cannot be used to create a label for a column, is there any way to get, at a minimum, the underscores to be used?

timhunt commented 1 year ago

This is a featur, not a bug, at least for us. Our goal is to create nice human-readable reports, which is why we replace _ with space in the colunn names to make the table titles.

I think that, if you have a scheduled report, and use the 'Export csv report to path / directory' feature, then you will get the raw CSV files copied to that folder, with the original column names from the database.

rmeske commented 1 year ago

Understood. Just hoped there was a means to have it formatted differently.