Tracking stale tickets within a sprint via reporting

[Vishay Krishan]

We have a large project with multiple collaborators. As the person chairing the meeting I wish to focus on priority items, blockers and stale/slow moving tickets(that may actually be blocked by resource constraints etc.).  In order to do this i want a report that:

1. Shows tickets which haven't moved to done from swim-lane/status xyz in a configurable amount days.
2. Shows tickets that have had no update in ten working days from swim-lane/status xyz.

Nice to have:
Group by story then assignee

This would allow me to email out the working day before to get people in the habit of actively updating, as well as understanding constraints/appropriate workloads etc.

[Bill Sheboy · Accepted solution]

Hi @Vishay Krishan  -- Welcome to the Atlassian Community!

Many of the things you ask about can be found with JQL queries. 

For example, use the following to find incomplete issues with no updates in 10 days in the current sprint, substituting in your values for project name and completion status

project = myProjectName AND sprint IN openSprints() AND status != Done AND updated <= -10d

Once you have filters which report what you wish, you may save them as a filter and then subscribe to them so they email you on a schedule.

If you have difficulities creating a specific filter, please post what you have and the community can help you.

Also know that if you are using a Classic project board, you can also save your filters as quick filters, allowing you to see the same results on the board during team meetings.

Best regards,

Bill

[Vishay Krishan]

Thanks Bill, i figured this one out yesterday however i'm having difficulty with SORT BY Parent, looks like that isn't available in JQL.

[Bill Sheboy]

Please try ORDER BY instead to sort the resulting issues from the query.

[Vishay Krishan]

Apologies i meant ORDER BY, parent isn't a valid sort value.

[Vishay Krishan]

"Not able to sort using field 'parent'."

Is the error, when using ORDER BY Parent. There is an enhancement already raised but no sign of resolution without a bespoke plugin.

[Bill Sheboy]

That is odd... You are using Cloud version, correct?

I just tried this for both Classic and Next-Gen projects and it worked for me:

project = myProject ORDER BY parent ASC

I added the ascending modifier as the default appears to be descending (DESC).