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; } } }

What is the equivalent JQL query for a scrum board backlog

unknown

I wish to implement a filter that provides the same results as the Scrum board's backlog lists. So that I can use the Export CSV feature found on the "Issues and Filters" page. And since there isn't the ability to export a csv file of the scrum board's backlog.

I don't want to modify it, but implement the same filter so that I can export only the backlog items.

I haven't found the (default ?) filter and while I'm close to emulating that filter, I want to know the exact filter.

Thanks

Accepted answers

Warren_mz9b4z

Hi David

If you go to Board settings, General you will see the filter that is used for your board.

To get just the Backlog items, you would need to add

AND Sprint not in openSprints()

somewhere logical in the filter

All comments

Warren_mz9b4z

Hi David

If you go to Board settings, General you will see the filter that is used for your board.

To get just the Backlog items, you would need to add

AND Sprint not in openSprints()

somewhere logical in the filter

unknown

Hi Warren,

Thank you for your reply.

I have done this but the issue count is an order of magnitude greater than shows on the board. (The backlog shows a count of 289 while there is over 6309 issues using the JQL of shown.)

What other places would further filter the one found under Board Settings > General?

I didn't do the original setup of this project, but I'm the lucky individual doing the clean up in the absence of a Product Owner. So combine that with not having JIRA administrator skills and being a novice at JQL - there may be some operator error on my part.

Hopefully this additional information my help in honing in on the root behavior.

Best regards,

Warren_mz9b4z

As I read your reply I realised a further thing to add - exclude all the Closed issues!

The Backlog only shows issues not in a sprint AND not in the closed state, so you'll need to also add

AND status != Closed

or whatever status is the equivalent for you - some have Done. Whilst in Board settings, go to Columns and see what the right hand status is - this is what you want to use in this query

unknown

While the suggestions haven't worked out with a simple filter, the identification of various status options allowed me to construct a more complicated JQL filter that emulates the backlog's filtering.

I checked some previous projects that I've worked on and the JQL that shows on the Board Settings produces the same result as a query on the Issues and Filters page. Apparently I've inherited a weird project. Clean up has started.

Thanks Warren for the pointers.

unknown

This is the query that gave me the exact numbers as shown in backlog.

<Your board query> AND type not in (Epic, Sub-task) AND status not in (<all done states in your board> accepted, closed, resolved, "IN QA") AND (sprint is EMPTY OR sprint not in openSprints() AND sprint not in futureSprints())

pavan_kumar.adurthi

This is what has given me the exact results

project = <Project Code> and status not in (<Statuses in the last column (Done Criteria) of columns section in Board settings>) and sprint is EMPTY AND issuetype not in (Epic, Sub-task) ORDER BY created DESC

davesoft11

With all the comments above, this is the one I'm voting for because it finally answers the question, at least better than the alternatives so far.

I can improve on it a little:

1) For "status not in (<Statuses in the last column (Done Criteria) of columns section in Board settings>) " just use and statusCategory="To Do", which also eliminates the IN PROGRESS category

2) For "issuetype not in (Epic, Sub-task)", use issuetype not in (Epic, subTaskIssueTypes()), which includes any number of other subTask issue types you may have defined.

So what is very close to accurate for me is:

project = <your_project> 
and issuetype not in (Epic, subTaskIssueTypes()) 
and (sprint is empty or sprint not in (futureSprints(), openSprints()) ) 
and statusCategory="To Do"

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

developer