Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,951
Community Members
 
Community Events
168
Community Groups

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?

8 answers

1 accepted

2 votes
Answer accepted
Phill Fox Community Leader Sep 25, 2016

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?

Phill Fox Community Leader Sep 25, 2016

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

Like Trixie Johnson likes this

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.

Can this be done without ScriptRunner?

Ditto to Matt Dodge....following.

Any solution for this yet?

Anyone found a way to do this without a plug-in?

issuefunction is not coming up Screen Shot 2020-07-16 at 3.19.33 PM.png

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

179 views 1 6
Read article

Atlassian Community Events