Filter issues based on whether the linked epic contains a string

I need to filter the list of issues showing in my scrum board based on the epics they are linked to. For example, I have a number of epics which begin with the string 'ISS' and so only want to show the issues related to them.

So far, I worked out the following JQL which seems to get me on the right track, but I don't know enough about the language, and the documentation and examples are lacking, especially for the second example.

JQL 1: 

issueFunction in linkedIssuesOf("issuetype = Epic and resolution is empty", "is epic of")

Intuitively, I would say something like, "issuetype = epic and name contains 'ISS'", but that doesn't work. It gives me the error, "Field 'name' does not exist or you do not have permission to view it." Currently looking at the list of acceptable fields in the docs here.

JQL 2:

issue.property[development].commit = 0

Similarly, I would like to find a list of acceptable arguments where development sits now, even just for a default issue. I'm imagining it could be something like,

issue.property['epic link'].value contains 'ISS'

 

If this is not at all possible, alternatively, it would be great if I could filter issues based on their labels. So, if I had a label, 'iss', then I could filter out all issues unless they have that label.

 

Thank you in advance!

2 answers

1 accepted

This widget could not be displayed.

I have solved it in two ways, both requiring a filter:

issuefunction in linkedissuesofrecursive("issuetype = epic
and summary ~ ISS")

This requires the summaries of the epics to be the same as their respective names, or at least contain the unique string ISS. If this is done, all issues related to the epics with ISS in their summary will be shown, the rest being filtered out. The two ways to use this:

  1. Add this filter to your shared project scrum board. It will filter out the issues you don't care about, and leave only those you do. The disadvantage with this solution is that it will not filter out epics you don't care about. This is a feature request (can't find the ticket, apologies) which has been closed by the powers at be, and seems like it won't be reopened. The advantage with this solution is that you can quickly switch to see the other issues for that board/project, something likely useful for project leaders.

  2. Alternatively, you can create an entirely new scrum board using the JQL shown above in the form of an issue filter. Be aware that the viewing permissions of that filter decide the viewing permissions of the scrum board. The advantage of this solution is it will only show the epics you care about (those with ISS in their summaries), allowing for a more focused and less-cluttered scrum board. This solution also helps enable many different groups which have shared versions/milestones across a company (e.g. my company) to share those milestones and thus be able to display overall progress very easily. The disadvantage of this solution is... I have yet to find one, because I have just began working with this solution, as it is the best solution to my problem/question.

 

If you have any questions about the simple steps it takes to accomplish either of the solutions, don't hesitate to ask. The difficult part (for me) was finding the right JQL for the job, and knowing where to paste it.

I get an an error that the JQL function “linkedIssuesOfrecursive(issuetype=epic)” was not found. Do I need a plugin for this to work?

It's most likely this function was turned off by your admins, because the query can end up locking down the entire server if you aren't careful (I may or may not have locked down the server of my 5k+employee company...).

@Michael Schmid, are you trying to accomplish the same thing I was?

Yes, I was also wanted to filter by a property of the linked epic. And I am on Jira Cloud. My project admin doesn’t care about tuning performance settings, they are all at their defaults (if even any are available on Jira Cloud).

But when search for linkedIssuesOf, I only find documentation with the Scriptrunner plugin, so I assume that plugin is a prerequisite for this to work.

 

This widget could not be displayed.

I found another angle that could work with some additional help:

issueFunction in linkedIssuesOfRecursive("issue in (ISS-13,ISS-14,ISS-15)")

where each of those issues is actually an epic.

It then shows the tasks/bugs/etc. associated with all of the listed epics. However, this will only work if I manually enter in the issue keys for each epic, but I need it to be automatic. It seems that it would work best to key off something in the name of the epic.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 11 hours ago in Statuspage

What are your best incident management tips and stories? #HugOps

 👋Community members! Downtime happens. And great incident response takes a village. Teams like Support, Dev, SRE, Ops, IT, and Marketing have to come together to resolve the problem while keep...

29 views 1 3
Join discussion

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