The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can i search the backlog issue from jql

Puneeth BS
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!
February 17, 2022

how can i write the jql filter to search the backlog issues

4 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Vishwas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 17, 2022

Hi @Puneeth BS  Welcome to Atlassian Community !!

project = ABC AND Sprint not in openSprints() AND Sprint not in closedSprints() AND Sprint not in futureSprints()

This query will return issues which are not included in any sprints of that project

1 vote
Alejandro Poupard
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!
February 24, 2023

Below query worked for me:

(project = sample
AND Sprint = empty)
OR
(project = sample
AND Sprint in (closedSprints())
AND Sprint not in (openSprints(), futureSprints()))

 

0 votes
Sukruth M S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 17, 2022

Hi @Puneeth BS , follow this JQL query:

JQL_BACKLOG.png

This query will give you the result of issues in the backlog.

Hope this helps you :) @Puneeth BS ,

Thanks,

Sukruth M S

0 votes
RISHAV KUMAR GUPTA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 17, 2022

Hi @Puneeth BS Just try with this query :

Project = ABC and status in (Backlog, Open, "To Do")

thanks ,

Rishav

Om Singh
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!
June 27, 2022

how can I get for old months -

Example --Jan, Feb , Mar...Jun

Comments for this post are closed

Community moderators have prevented the ability to post new answers.