Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Tracking stale tickets within a sprint via reporting

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.

1 answer

1 accepted

0 votes
Answer accepted

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,


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.

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

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

"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.

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).

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you