Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

JQL Query for searching Unresolved Issues (Story) in the sprints for different Quarters 2020

Simar
Simar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
April 28, 2020

Hi, 

I am trying to create JQL Query to search all the unresolved issues (story) in the sprints for Q1 2020 but i am unable to identify the criteria for the query to show correct results. I am using the below query:

project = XYZ AND issuetype = Story AND resolved is EMPTY AND updated >= StartOfYear() AND updated <= StartOfYear(3M) AND sprint in closedSprints()

Comment
Watch
Like Be the first to like this
1620 views

1 comment

Comment

Log in or Sign up to comment
LarryBrock
LarryBrock
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
May 11, 2020

Hi @Simar , what results are you missing when you run this query?  It appears to be syntactically and logically correct, assuming sprints are being properly closed.

Like
Reply

Recommended Learning For You

Level up your skills with Atlassian learning

Learning Path

Get started with Jira Software

Jira Software

New to Jira Software? These short, self-paced courses will teach you what you need to know to get up and running quickly.

2.8h Beginner
Free

The Beginner's Guide to Agile in Jira

Jira Software

Learn what agile, kanban, and scrum are and how agile works in Jira Software.

1.5h Beginner
Free

Realizing the Power of Jira Reporting and Dashboards

Jira Software

Use out-of-the box reporting and dashboard capabilities to view and assess progress and bottlenecks within projects.

1.5h Intermediate
On Demand
groups-icon
New to Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events