Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

JQL for multiple filters together

Deleted user Dec 12, 2019

Hi All,

I have a case here.

I am in Sprint 3 now.I want to see all the stories which are still open from sprint 1 and want to know their priorities too.

Is there a way this can be done?

I am a newbie here so not sure if this has already been discussed in the forum.Please tag me if yes.

Thanks,

Payel

3 answers

2 accepted

0 votes
Answer accepted
Jack Community Leader Dec 12, 2019

Try this...

Project = abc resolution is empty and sprint in (sprint 1, sprint 2)

assuming you are on sprint 3 now, this should find all issues in project abc that are unresolved and were in sprint 1 and/or sprint 2.

0 votes
Answer accepted

@[deleted]usually when the task is moved to a new sprint it is still connected to the old one, i.e. slipped issues are in several sprints.

 

Saying that, it would be enough for you to simply search for:

resolution is empty and sprint = sprint1 order by priority

Hi @[deleted] ,

Please try below JQL query 

ex :Sprint in (123,456,678)

 

replace 123,456,678 with your sprint ID. Start typing sprint name it will automatically takes the sprint id.

Deleted user Dec 12, 2019

Hey @Sreenivasaraju P Not sure I got it completely.How will this query show up all the stories which have spilled over since sprint 1 and their priorities?

Thanks,

Payel

Hi, 

What do you mean by slipped? (generally status is in to-do or in progress)

 

Sprint in (123,456,678) and issuetype = Story and status in ("To Do", "In Progress")

 

note : you can replace the status or issuetype as per your requirement.

Deleted user Dec 12, 2019

I guess u didnot get my question .Tasks which are not completed in 1 sprint gets spilled over to the next sprint.

My query is to get the list of all such spilled over tasks along with their priorities.

Payel 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,582 views 22 33
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