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

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

Nested filtering (again) Edited

I have a number of Epics that belong to different projects/delivery teams and to a number of Initiatives.

I want to create filter that returns all the Epics that are children of those initiatives. Again, as they belong to different projects I lose the ability to use that in the filter. Also, I need it dynamic. I want to avoid using a static list in (initiative_2, initiative_2,...). Also, I want to avoid using labels, as those can be changed easily and issue creators may forget to label new issues.


My idea is to have:

Filter_1 = ListOfInitiatives

Filter_2 = issueType = Epic AND parentLink in ([Filter_1])

Search: filter = Filter_2


I have seen some threads that mention a couple of add-ons to accomplish what I need. Is there a way to do it with the core product, no add-ons?

Should we just get an admin to add a custom field and make it mandatory?

1 answer

1 accepted

Hi @Joel Blazquez Sargatal ,

It's not possible to get the results you're looking for with standard JQL. For one off-jobs you can get away with Excel export.

In your case, however, you really should consider installing an app. This way everything will be automatically handled by the indexing service. While you are researching solutions, you may consider our cloud indexing service:

After installing the app you'll be able to search for children of your initiatives:

issue in childrenOfIssuesInQueryRecursive("project in ('ACME', 'DEV') and type=Initiative")

You can find out more in the docs.

I hope it's useful!

Suggest an answer

Log in or Sign up to answer

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