Project

General

Profile

Actions

Feature #8298

closed

Require the SQL query that generates CSV

Added by shubham chakraborty almost 13 years ago. Updated almost 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-05-05
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid

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.

Actions #1

Updated by Etienne Massip almost 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.

Actions

Also available in: Atom PDF