Query to see how long someone has been an assignee before working on a ticket
I am trying to build a report/query in Redmine to see how long it takes my team to start working on a ticket.
Is there a way to do this?
We have the following available columns:
If I use the Updated column, it wants me to enter a specific date, so that won't work.
RE: Query to see how long someone has been an assignee before working on a ticket - Added by Bernhard Rohloff over 1 year ago
I think you can't achieve your goal by using the query functions of Redmine because it doesn't track when an issue has changed for the first time. The only information you get is when the issue was created, updated or closed. There is no definition of what the 'start' actually is and it may also vary from workflow to workflow.
So what you actually can do is to fetch your issues by a script and get your information by processing the journal entries of each one.
It's maybe not so elegant, but it should do the job. ;-)