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

Building a complex JQL: All Epics with certain Label with their issues & subtask Edited

Hi!

Maybe someone can help me out, couldn't find this answer at the Fora nor at Google.

 

I need te build a JQL Issue Filter where I would like to get as a result:

  • All Epics with the Label "ABC"
    • + All the Issues/Stories (with or without any label) belonging to these Epics
      • + All the subtasks (with or without any label) belonging to these Issues./Stories

 

I've been trying with 'In parent' and stuff but couldn't figure out how to get this without using plugins.

 

Anyone?

We are using Jira Server V8.4.1

 

Thomas & Rory

 

 

 

2 answers

1 accepted

2 votes
Answer accepted

Hi tfreriks,

You need a third-party plugin to create such a complex query.

 

After installing JQL Booster Pack (FREE), you need to type the following:



(type = Epic AND labels = ABC) OR issue IN issuesInEpics('type = Epic and labels = ABC') OR issue IN subtasksOf("(type = Epic and labels = ABC) OR issue IN issuesInEpics('type = Epic and labels = ABC')")

 

The above query will retrieve:

1. - any Epic labelled as ABC,
2.- any subtask directly created under those epics,
3.- any stories/issues within those epics on the Epic Link field
4.- or any subtasks created under issues matching point 3

Regards

Works like a charm!

Great answer...

 

I had to do some tweaking with the filter, but givin the question, this answer was perfect!

 

Thx @Jack Nolddor -Sweet Bananas-

0 votes

Hi @tfreriks 
I think it is not possible without plugin.

Using ScriptRunnner, you should be able to do your request like

 

issueFunction in issuesInEpics("summary ~"ABC"")

 

Hope it helps !

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

229 views 1 2
Join discussion

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