Feature #8298
closed
Require the SQL query that generates CSV
0%
Description
Where can i find the SQL query that is used to generate the CSV which exports all the columns of all issues?
Is the sql query built in parts and then executed OR is it stored somewhere?
It would be nice since for all our reports we need automate the csv export and hence we are thinking of making a sql file and exporting all to XLS or CSV format.
Updated by Etienne Massip over 13 years ago
- Category deleted (
Database) - Status changed from New to Closed
- Resolution set to Invalid
shubham chakraborty wrote:
Where can i find the SQL query that is used to generate the CSV which exports all the columns of all issues?
Is the sql query built in parts and then executed
Yes.
It would be nice since for all our reports we need automate the csv export and hence we are thinking of making a sql file and exporting all to XLS or CSV format.
You could raise your debug level in config/environments/production.rb and get the final SQL statement in Redmine log file after you ran the query in the Issues tab.
Please ask your question in forum, this tracker is for bugs and features only.