Hi, My current query currently pulls out the tickets that were closed in the sprint before the last one and were moved to the next sprint. (Not sure why this is happening). The tickets in question are DONE and haves two sprints (A, B) . I need a query that will only show the tickets that were resolved in sprint B. Please advise. Current query: issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = 988. In results, I see tickets that are Done but both sprints A and B...

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for tickets closed in a specific sprint

Samantha Sharkov_ef1nrk

Hi,

My current query currently pulls out the tickets that were closed in the sprint before the last one and were moved to the next sprint. (Not sure why this is happening).

The tickets in question are DONE and haves two sprints (A, . I need a query that will only show the tickets that were resolved in sprint B. Please advise. Current query:

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = 988.

In results, I see tickets that are Done but both sprints A and B...

Accepted answers

Pramodh M

Hi @Samantha Sharkov

Could you please try below query and let me know the result

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint in openSprints()

OR

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = B AND sprint not in closedSprints()

Thanks,
Pramodh

All comments

Pramodh M

Hi @Samantha Sharkov

Could you please try below query and let me know the result

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint in openSprints()

OR

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = B AND sprint not in closedSprints()

Thanks,
Pramodh

Samantha Sharkov_ef1nrk

Thank you very much, I will try. When I run this query I usually have both sprints closed..

Samantha Sharkov_ef1nrk

My issue was solved here https://community.atlassian.com/t5/Jira-questions/JQL-for-closed-date-vs-created-date/qaq-p/595575 with status changed to Done after "2022-03-17"

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud