Where are status change details for an issue stored in the DB?
Added by Ian Jarvis 3 months ago
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?
Redmine version 5.0.4.stable
Ruby version 3.1.3-p185 (2022-11-24) [x86_64-linux-musl]
Rails version 6.1.7
Database adapter PostgreSQL
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine theme Classic
no plugin installed
RE: Where are status change details for an issue stored in the DB? - Added by Ian Jarvis 3 months ago
I've found it. It's all stored in journals and journal_details.