How to get a report of issues that have stayed in one status for a assignee for the longest period?

Question

Hi

We want to show a report (either on dashboard gadget, or reporting, or other) of tasks that have stayed in one status for a long period for a given assignee. Please advice on how to get this done.

Thanks,

Rakshatha

Inactive Stephen · Accepted Answer

Hi @Rakshatha Shetty

We built a query (in Jira Server) to look for all issues not transitioned within a specific time period, which should meet your needs - this is how we did it:

* Create a search query to look for all issues where the status was changed within a long time period - we chose 28 days. This query looks like this: "status changed after -28d"
* Save this filter and note the filter ID (in the URL)
* Build a new query to look for all issues which do not meet this query - so for example: "filter != 12345" - where 12345 is your first filter's ID

^ To extend this example, if I wanted to look for all Epics in a project in the status 'New' which have not transitioned within 28 days, it might look like this:

* project = ABC and issuetype = Epic and status = New and filter != 12345

You can then visualise the filter however you want - as a Dashboard gadget, a quick filter on your board or similar.

Ste