Documentation for JIRA 6.4 (This documentation includes the project navigation sidebar). Not using this? See below:
(JIRA 6.4 without sidebar documentation | JIRA 6.3.x documentation | JIRA Cloud documentation | earlier versions of JIRA)

Skip to end of metadata
Go to start of metadata

There are 3 plugins available in JIRA Extension Page which might be able to fulfill the requirement:

13 Comments

  1. Is there any way I can create a report where I'll have something like

    ISSUEKEY-1, Status1, Transition1, Time

    ISSUEKEY-1, Status2, Transition2, Time

    ISSUEKEY-1, Status1, Transition3, Time

    Just the same information that we can see on the History tab, but as a report. I understand this is database query. Any hints?

      1. Do you know if there's any way to query issues with JQL based on this information?

  2. I'm wondering the same about aggregate transitions times. Does anyone know the tables to query for this?

  3. Brian Rafferty You can use Script Runner's JQL functions for the aggregate piece. https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-AggregateExpressions

     

    ,.Luzia Mendes, if Jamie's plugin doesn't have that function, it should be easy enough to script your own without writing anything against the DB. https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-Writingyourownfunctions

  4. Thank you, @Eddie Webb (did that work?). Script Runner is new to me, but I'll enjoy exploring it. Thanks, too, for the link to Jamie's information.

  5. Thank you, @Eddie Webb (did that work?). Script Runner is new to me, but I'll enjoy exploring it. Thanks, too, for the link to Jamie's information.

  6. Asking the same question as in first comment, can we capture the time in status in a report.

    We just want to track that whether some status transtions are being within less than a specified time e.g. 5 seconds/mins...which might be the case when users just click next..next..next.

  7. Is there a way to exclude weekend hours from this feature? 

  8. I also need "Time Spent in A Workflow State" for a set of issues. Results of my research...

    If you're using JIRA On Demand, JIRA Suite Utilities will give you per issue data that cannot be queried in JQL. If you're running JIRA on a server, there are lots of plugins that help - Time In Status and Better Excel are two that come to mind.

    I'm not an expert at this, so if someone finds a way to make exporting the relevant data from JIRA On Demand, please let me know.

  9. We have JIRA Enhancer Plugin, which provides handy fields like: Time Between (two statuses), First Response Time, etc.