Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Sprint Board - filter subtasks completed in previous sprint

Edited

We use story swimlanes in our sprint boards with subtasks being moved throughout each column.

Sometimes stories aren't completed in a sprint and this means the sprint board can get cluttered with subtasks that were already completed in previous sprint.

We would like to create a quick filter to be able to easily hide subtasks completed in the previous sprint.

 

I attempted the following solution

  1. Added a custom Text Field (single line) named "Done Sprint" 
  2. Set the text field to the active sprint name via a jira automation when the subtask is transitioned to done
  3. Tried to add this quick filter: "Done Sprint" IS EMPTY OR "Done Sprint" IN openSprints()"

This last step outputs the following error: 

The operator 'in' is not supported by the 'Done Sprint' field.

What is the quick filter query I should use in this case (assuming such a query is actually doable)? Would there be any other way to have the option not to display subtasks completed in previous sprints on the sprint board?

1 answer

1 accepted

0 votes
Answer accepted

Hi @Guillaume Lebedel 

Remember that JQL is not a SQL, and so things like openSprints() probably only work with the actual sprint field, and not generically with any fields.

You seem very close to a solution already, and if you do not need the actual "done sprint" value, how about this idea: just set a "hide" indicator.

  • Run an automation rule when the sprint completes, marking subtasks (or other things) not to show again with a different custom field indicator (e.g. "HideOnBoard")
    • trigger: sprint completes
    • branch: on JQL for the issues to hide in the future (e.g. any done subtasks)
      • action: edit the issues to set custom field to "Yes"
  • Use a quick filter to ignore those (e.g. "HideOnBoard" IS EMPTY)

Another okay way to do this is with just JQL in a quick filter, hiding any "done" subtasks that were in prior sprints...although that will hide stuff as soon as it finishes in the current sprint:

project = myProjectName AND issuetype = Subtask AND statusCategory = Done AND sprint IN closedSprints()

 

Kind regards,
Bill

Hi Bill,

The `HideOnBoard` idea was indeed a much simpler solution! I've implemented it successfully and it achieves my initial goal.

Thank you for your help!

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

163 views 1 5
Read article

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