time in source status

Question

Hi,

I'm looking for the table about transition and time in source status on the jira database schema but I cannot find it. Is there anyone who can help me to find that data please ?

Thank you,

Arthur

Анастасия Абызова · Answer

Hello, Tell me, please, how did you solve this problem?

Arthur Castagnac · Answer

Hello Alexey,

I already use the changeitem tables for the new, in progress and done status. But for all the custom status it will be much more easier if those values were stored somewhere ...

Thank you for your answer

Alexey Matveev · Answer

Hello,

I doubt these values are stored in the database ready to pick up. You can calculate this info based on the changegroup and changeitem tables. These tables store the history of every issue in Jira. You can get info when the status field was changed and count time until the status field was changed again.