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

[Rakshatha Shetty]

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 solution]

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

[Rakshatha Shetty]

Thanks for the response, it worked for me.