Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

How to write a filter to show the Initiative and all epics and stories underneath

There are two individual boards/teams working on the same project.  I have created a new board that I'd like to just pull out only stories and epics under an Initiative I created that should only display epics and stories underneath that Initiative.

I can pull the Initiative in, but don't know how to structure the filter to pull in epics/stories underneath it.

1 answer

1 accepted

1 vote
Answer accepted

Hello Tim,

Try this JQL : issuekey in childIssuesOf("INIT-007")

The above JQL will return all child issues below INIT-007, and not just the child issues at the epic hierarchy level. This means all the epic ,stories and subtasks will be returned.

You can read more here - Searching for issues using Portfolio details

Best,
Sachin.

That was perfect Sachin.  Epics and Stories are now showing.  I'm also trying to show these in the Portfolio and the Story Mapping view, and this filter will definitely help.

Thanks!

Tim, glad to hear that! Can you accept my answer so it could help others as well! 

Hi Sachin...hoping to add one more question to my question above, as it worked on one board, but not the other where there are two boards involved. 

I have the following filter to pull epics and stories from two different boards, using your filter, where TRA and SPD are the two Projects (different boards) and tra-1655 is the Initiative I'm trying to pull all stories/epics from.  It isn't pulling anything back, even though I know there are epics and stories under that initiative on the TRA board.

project in (TRA, SPD) AND issuekey in childIssuesOf("tra-1655") ORDER BY Rank ASC

Any ideas?

Hey Tim, are you using the same filter on two different boards on those two different projects, and can you tell me which board is pulling the issues and which isn't ? 

I am an admin on my board, and that is where I've entered some test stories that should have been displayed with the filter above.  Neither board's stories are being displayed on the new third board.

If the above JQL is giving you the results then there shouldn't be any problem of those issues getting pulled onto your board,. However, can you check the "unmapped statuses" from you board --> configure --> columns and map them to the correct columns. 

The childIssuesOf worked on one my boards. Where it is not working is when I'm trying to bring issues from two different boards/two different projects into a third board so it only displays work from a single Initiative. Here is my query:

project in (TRA, SPD) AND issuekey in childIssuesOf("tra-1655") ORDER BY Rank ASC

Where TRA and SPD are two separate projects and tra-1655 is the initiative I'm trying to get all epics and stories to display on the third board. It just gives me this message - Unable to find an issue with matching key tra-1655.

Figured it out...the Initiative ID has to be all caps.  When I changed it to TRA-1655, it started to work.

Thanks for all of your help...really appreciate it!

@Tim McMonigle Did this filter show in portfolio for you.  I used the filter to pull issues from an initiative and it works great in Jira, but when I use the same filter to build a plan in Portfolio for Jira, only the epics show up...no stories (or any standard-issue types).

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Advanced Roadmaps

Introducing Advanced Roadmap’s new dependency report

To see this feature in action check out our recent dependencies demo here: https://www.youtube.com/watch?v=eQu5VsUqyZA Keeping on top of your dependencies is a key part of ensuring project success....

150 views 2 6
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