How to filter for all epics with a certain label and all issues in these epics

Hi,

 

What I want:

I am using JIRA agile with Scriptrunner installed and want to do the following:

for an agile Board, I would like to create a JQL filter that mainly filters all epics with a certain label. And the filter should also include all issues in these epics. I want to do this because in my JIRA project there are multiple big topics and I want to create an agile board for one of these topics.

E.g. there is the big topic "test". I would then create epics and add the label "test" to those epics. Additionally I would create issues in these epics (but of course the have no or different labels).

I want them all now to turn up in my agile board.

 

What I already tried:

  • Create a filter to filter all epics (stored as JQL Filter "MyEpicFilter")
project = MyProject AND issuetype = Epic AND labels in (Test) AND resolution = Unresolved
  • Create another filter which uses the first filter as subfilter
issuefunction in linkedIssuesOf("filter = 'MyEpicFilter'")
  • and then combine both to get the issues and epics
issuefunction in linkedIssuesOf("filter = 'MyEpicFilter'") OR (filter = "MyEpicFilter")

but this doesn't work and creates a cyclical reference.

 

In the end I want to end up with an agile board where epics can be added by simply creating a new epic and assigning the label to it.

How can this be solved?

4 answers

1 accepted

Hi Claudius Eisele

Can you confirm what name you are saving the final filter as? I suspect that you are trying to implement 

issuefunction in linkedIssuesOf("filter = 'MyEpicFilter'") OR (filter = "MyEpicFilter")

whilst JIRA still thinks you are working on "MyEpicFilter"

 

If the final filter is a different name to "MyEpicFilter" then we need to dig deeper. But I can confirm that I tested your approach on a local instance making sure I named each filter as I went and it worked fine.

Hope this helps.

 

Phill

Hi @Phill Fox [Adaptavist],

Thanks for your answer.

I did not yet save the final filter, I was just typing it into the advanced JQL filter input in JIRA. So the name is free to define - but yes it should be something different as "MyEpicFilter". For example: "MyBoardFilter".

 

I even could not save it because I would need to execute it first but it always ends up with the following error message:

Field 'filter' with value 'MyEpicFilter' matches filter 'MyEpicFilter' and causes a cyclical reference, this query can not be executed and should be edited.

Do you have any idea what is different from your filter and mine if your one works?

Hi Claudius Eisele

I suspect JIRA still thinks it is working the filter 'MyEpicFilter'  I would suggest the next step is to copy the JQL and open a new tab for the issues filter and paste in to there. In this way you are breaking the connection with 'MyEpicFilter'. This was how I built my test case to match yours.

I have just done what you described of typing the content in to the issues Filter after defining the included filter and got the same error message that you showed.

Phill

Thanks @Phill Fox [Adaptavist],

 

executing the filter now worked - my fault. sad

 

It now works, really great! smile

I even wanted to include the subtasks so I built the following query:

issuefunction in linkedIssuesOf("filter = 'MyEpicFilter'") OR (issueFunction in subtasksOf("issuefunction in linkedIssuesOf(\"filter = 'MyEpicFilter'\")")) OR (filter = "MyEpicFilter") ORDER BY Rank ASC

 

Just if someone else wants to do such a query.

 

Thanks again,


Claudius

Wow, thanks for this answer. It was EXACTLY what I was looking for. I modified the final filter to include "is epic of" as below:

issuefunction in linkedIssuesOf("filter = MyEpicFilter", "is epic of") OR filter = MyEpicFilter ORDER BY Rank ASC

Can this be done without ScriptRunner?

Same question as Dion Jones, is there any way to do this without ScriptRunner? I have the same use case as OP. Want to be able to tag/label an epic and have all of the issues of that epic appear on a certain board.

0 vote

Ditto to Matt Dodge....following.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

345 views 3 11
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you