Project

General

Profile

Actions

Feature #5046

closed

Status Update Difference

Added by shubham chakraborty about 14 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2010-03-11
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid

Description

Is there anyways i can have the values of the time difference between 2 consecutive status updates of an issue in redmine, for all issues....any plugin or normal SQL query to run.

Or if anyone knows the exact SQL query to run on MySql, can you kindly fwd it to me.

I am using the TIMEDIFF function to get the difference...but i need the query for making this for all issues... as well as generalising it where i dont have to input the journalized_id and id values everytime..

Thnx in advance.

Actions

Also available in: Atom PDF