Query to see how long someone has been an assignee before working on a ticket

Added by Lyle Smart about 1 year ago

Hello,

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:
Created
Tracker
Status
Priority
Subject
Author
Assignee
Updated
Category
Target Version
Closed
Related issues

If I use the Updated column, it wants me to enter a specific date, so that won't work.

Any thoughts?

Thanks

Replies (1)

RE: Query to see how long someone has been an assignee before working on a ticket - Added by Bernhard Rohloff about 1 year ago

Hello Lyle,

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. ;-)

Kind regards,

Bernhard

(1-1/1)