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:

10 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?