Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Big Picture - How can I create JQL-filter that shows me tasks from the Board-iteration (sprint) Edited

Dear all,

How can I create a JQL-filter that shows me only tasks from the specific selected Board-iterations (sprints)?


1) I see that each iteration on BigPicture's New Board (2.0) has its own Iteration ID, and I thought it could be used like this:

IterationID in (ITER-3)

but I cannot find the right field for JQL (instead of "IterationID" in my example) if this solution is possible at all...


2) Another theoretical way that I saw - to use field "End Date"

"End date" = 2020-07-15

but these dates are not always correct, even with precise period alignment in iterations. It was tested in 2 Jiras (Cloud and Server)...


So I ask you to help me mainly with the first case (using Iteration ID).



big picture jira iteration filter.png


2 answers

Hello, I'd try mapping BigPicture iterations to Jira Sprints, as shown in figure 1.

For clarity, I'd try to use the 'ITER-322' as the name for a corresponding Jira Sprint.

Then, you'll be able to use 'Sprint in (ITER-322)' as evident in fig. 2.



Fig. 2


Interesting solution
Could we do it without any manual sprint synchronization?



I have the same question: is the field "ID (which could be PI or ITER) somewhere available in an issue, so I could use it for a filter?

Hello @Martin Härri

By default, BigPicture creates a text custom field “Program Increment.” If you configure PI Scope Definition based on the “Program Increment” field value, e.g., PI-1, you can use JQL based on the field value.

Regarding Iterations, the most common way is synchronization based on Sprints, which is a Jira field. Therefore BigPicture/BigGantt does not create an additional field, “Iteration.” 

However, you can create your own custom field, use it as a base of synchronization, and then use it in your JQL search. 


Like # people like this

Thank you, @Anna-SoftwarePlant . That would actually solve my request, however, I see that synchronization of PIs is only possible for users of BP Enterprise, and we are using PB Standard :-(

However, it seems that this is possible for sprints, so I'll try this out.

Hello @Martin Härri

Do you still use the BigPicture 7 line? Indeed, in the previous versions, synchronization on the PI level was available only with BigPicture Enterprise. 

However, in the current version available on the Marketplace - BigPicture 8.0.16, this functionality is available in the standard version. Please consider upgrading to the latest version.

In BigPicture 8, we introduced a number of improvements and new features (Portfolio Management, Boxes, Scenarios, New Gantt, etc.). In the article: When and how to update? - you will find a review of the main changes in BigPicture 8. 

Just let me know if you have more questions. I will gladly answer them.


Like # people like this

I like new JQL-features by last versions of BigPicture!

If BP is now capable of this, I dream of filters that would allow displaying a list of related tasks from a hierarchy of 3 or more levels (with different parents).

For example, several Epics, Stories nested in these Epics, Sub-Stories related to the found Stories.

Like Anna-SoftwarePlant likes this

Hi @Titov Alexandr

You can use one of BigPicture enhanced JQLs, that will return returns all of the children of a particular task up to the X-th level of hierarchy:
issue in allBoxDescendantTasks(BOX-ID, TASK-KEY,X).

More information you can find in our documentation.

If you expected a different outcome, please provide us more details.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

New cloud apps roundup - June 2021

Since our last roundup in April, Atlassian's Marketplace Partners have added over 100 new cloud apps to the Atlassian Marketplace to help your teams work more efficiently. Let’s take a quick look a...

492 views 6 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you