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 Query for extracting all backlogs related to a project

Pranay Verma

I wanted to extract all backlogs related to a particular project. I read one of the queries related to this and came up with something like this :

project = *project_name* AND issuetype in (Task, Bug, Improvement, "New Feature", Enhancement) AND sprint is EMPTY AND resolution = Unresolved and status != Closed

But this doesn't seem to be working.

Can someone help me out with how all backlogs can be extracted?

Accepted answers

Leo_e8op2r

Hi @Pranay Verma,

If I got you correctly, you may not get the exact count shows in the backlog as your result

it's because any tickets moved from sprint to backlog during sprint closing then the sprint field is not empty on those tickets.

I hope below query may help you to fetch your backlog tickets

project = *project_name* AND issuetype in (Task, Bug, Improvement, "New Feature", Enhancement) AND (sprint is EMPTY OR Sprint not in (openSprints(), futureSprints())) AND resolution = Unresolved and status != Closed

Regards,

Leo

All comments

Sreenivasaraju P

Hi @Pranay Verma ,

What do you mean by not working. It is not returning all the tickets or returning more ticket. can you give more details..

Leo_e8op2r

Hi @Pranay Verma,

If I got you correctly, you may not get the exact count shows in the backlog as your result

it's because any tickets moved from sprint to backlog during sprint closing then the sprint field is not empty on those tickets.

I hope below query may help you to fetch your backlog tickets

project = *project_name* AND issuetype in (Task, Bug, Improvement, "New Feature", Enhancement) AND (sprint is EMPTY OR Sprint not in (openSprints(), futureSprints())) AND resolution = Unresolved and status != Closed

Regards,

Leo

Bill Sheboy

Yes, and...

Hi @Pranay Verma

What is the problem you are trying to solve with this query? Knowing that will help the community better answer your question.

Thanks, and best regards,

Bill

Pranay Verma

Hi @Bill Sheboy So basically, I wanted to retrieve all the backlogs that are present in a particular project, be it a part of a sprint or not, just all the backlogs. You can just ignore the query that I'd created, and help me with a fresh query.

Thanks,

Pranay

Muhammad Ramzan_Atlassian Certified Master_

If you want to show all backlog items then please only use the following query it will show all backlog items.

project = *project_name*

Pranay Verma

Hi @Muhammad Ramzan_Atlassian Certified Master_

I'm afraid this along with the backlogs will also give the ones which aren't in backlogs.

Pranay Verma

Hi @Leo This query is partially working for me. Thanks a lot!!!! The only thing is I'm trying to do this using Python.

I've tried something like this:

issues_in_backlog = jira.search_issues('project = \"AM+ Assets Delivery\"' AND issuetype in (Task, Bug) AND (Sprint is EMPTY OR Sprint not in (openSprints(), futureSprints())) AND resolution = Unresolved AND status != Closed)

But this is giving a syntax error, that I tried in both the code as well as the Advanced Search textbox. Could you help me with the syntax? Then I could probably filter my query, that'll provide me with all the relevant backlogs.

Leo_e8op2r

Hi @Pranay Verma,

I don't find any issue with query and I'm not familiar with python. if you could attach the screen shot of advance search error. I may get something to suggest

Pranay Verma

Hi @Leo ,

Earlier, I'd run this query for getting all the issues in the project, and this worked perfectly for me. I'm pasting the query so you could use it for your reference.

issues_in_project = jira.search_issues('project = \"One+ Dev Proj\"', startAt=0, maxResults=1000,validate_query=True,fields=None,expand=None,json_result=None)

So, the only difference that should happen here will be in the JQL, since it'll be refined only for getting the backlogs.

I've attached the Advanced Search box screenshot, where I'm getting the Syntax Error, for the Backlog Query.

Could you please have a look at this query, and point out where I'm going wrong.

Thanks,

Pranay

Bill Sheboy

Hi @Pranay Verma

Thank your for clarifying your goal.

How about this idea: make a simple Kanban board, with columns showing any of the relevant status values for Todo (e.g. backlog), In progress, and Done. Then make a filter including the projects, status values, etc. that you are interested in.

Best regards,

Bill

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software