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 = UnresolvedCreate another filter which uses the first filter as subfilterissuefunction in linkedIssuesOf("filter = 'MyEpicFilter'")and then combine both to get the issues and epicsissuefunction 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?

Community
Products
Jira
Questions
How to filter for all epics with a certain label and all issues in these epics

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks @Phill Fox [Adaptavist],

executing the filter now worked - my fault.

It now works, really great!

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Trixie Johnson likes this

7 votes

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.