nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

[JQL] Finding epics that are related to issues within a different project.

Lance Wilson

My company’s metrics team is looking for ways to calculate how we are keeping track of our company’s velocity. We have epics that are linked to issues within a particular project, we’ll call it ACME. And they want me to create a rich filter to query for those epics linked to ACME issues and subsequently find all issues linked to those epics. What would be the best way to query for these issues? I’ve tried on my own and feel like my searching falls short, missing some issues.

I use Scriptrunner and the version of Jira I’m on is 7.13.

Accepted answers

Ansar Rezaei

First, do this search and save it as a filter with a name, for example, "A":

issueFunction in linkedIssuesOf("Project=ACME") and issuetype = epic

Then do this search:

(issueFunction in linkedIssuesOf("Project=ACME") and issuetype = epic) or issueFunction in issuesInEpics("filter = 'A' ")

All comments

Tuncay Senturk _Snapbytes_

Hi @Lance Wilson

As far as I understand you want to list issues in epics and you already have Script Runner.

Did you have a chance to check issuesInEpics JQL function?

For instance you can type JQLs as below:

issueFunction in issuesInEpics("project = ACME and status = 'To Do'")

issueFunction in issuesInEpics("key in (EPIC-1, EPIC-2)")

I hope I was clear,

Tuncay

Ansar Rezaei

First, do this search and save it as a filter with a name, for example, "A":

issueFunction in linkedIssuesOf("Project=ACME") and issuetype = epic

Then do this search:

(issueFunction in linkedIssuesOf("Project=ACME") and issuetype = epic) or issueFunction in issuesInEpics("filter = 'A' ")

Lance Wilson

See, I would have guessed this would be the way to do it, but it turns out the way people have linked and related these epics is a jumbled mess. Most aren’t in the “issues in epic” list, so I tried to list out from your first comment as my filter. Then tried to used the “linkedissuesOf” command but I’m not sure how I can list all forms of relation in one bracket...

Ansar Rezaei

Hi @Lance Wilson

Could you explain your problem in more details/

As far as I know, your concern is about different link type in projects, and with this query, you list all of them:

issueFunction in linkedIssuesOf("status = Open")

Lance Wilson

Ok, so I should note that my issues are related to finding linked issues in every possible format. I’ve created countless filters that have used

“issueFunction in LinkedIssuesOf(“Project =ACME”, “related to”)”

and a couple more OR statements for Different issue links.

Is there a Scriptrunner IssueFunction that shows all issue links? I’m thinking it’s “lssueFunction in LinkedIssuesodAll()”

but looking at the scriptrunner wiki, doesn’t look like it...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server