Where are status change details for an issue stored in the DB?

Hi all

I want to get the status change info for an issue from the DB. Which table is it stored in? Or, if I can use the API, which endpoint do I need to use. I can't find any info which will allow me to find out the timestamp when an issue changed status. I'm basically trying to pull together an SLA report so I can show how long an issue took to progress from New -> In Progress -> With Customer/Resolved?

Installation info:

Environment:
Redmine version 5.0.4.stable
Ruby version 3.1.3-p185 (2022-11-24) [x86_64-linux-musl]
Rails version 6.1.7
Environment production
Database adapter PostgreSQL
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine settings:
Redmine theme Classic
SCM:
Subversion 1.14.2
Mercurial 6.1.1
Bazaar 3.2.1
Git 2.36.4
Filesystem
Redmine plugins:
no plugin installed

Replies (1)

RE: Where are status change details for an issue stored in the DB? - Added by Ian Jarvis almost 2 years ago

I've found it. It's all stored in journals and journal_details.

(1-1/1)

Project

General

Profile

Redmine