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; } } }

Returning issues from epics that in turn are returned from a filter

Ragni Jayanthi_w4uieo

Hello!

I am trying to return all issues from epics in one of my projects that have a specific label. The following doesn't work:

status not in (Closed, Done, Resolved, Dev) AND "Epic Link" in (project = ABC AND labels = XYZ)

I am getting a syntax error:

Error in the JQL Query: Expecting ',' or ')' but got '='. (line 1, character 73)

I have a filter that returns the Epics, but using"Epic Link" in (Filter = 12345) doesn't work either. Get the same error message as above

PS: Is there a easier way to identify character 73 without sitting here counting characters?

Accepted answers

Kat Warner

"Epic Link" in (labels = XYZ) is not valid JQL therefore your clause "Epic Link" in (project = ABC AND labels = XYZ)

I'm not sure how to combine a filter with the epic link search.

All comments

Kat Warner

"Epic Link" in (labels = XYZ) is not valid JQL therefore your clause "Epic Link" in (project = ABC AND labels = XYZ)

I'm not sure how to combine a filter with the epic link search.

Bill Sheboy

Hi @Ragni Jayanthi -- Welcome to the Atlassian Community!

JQL is not a SQL, so the syntax you noted cannot work with out of the box Jira:

..."Epic Link" in (project = ABC AND labels = XYZ)

To do what you ask with out-of-the-box Jira, you would need to find the epics first, and then create your own CSV list to find the remaining issues, in two steps:

project = ABC AND labels = XYZ ... to get your epics, such as EPIC-1, EPIC-2, EPIC-3 and then substitute that into the other query
status not in (Closed, Done, Resolved, Dev) AND "Epic Link" IN (EPIC-1, EPIC-2, EPIC-3)

Best regards,

Bill

Kat Warner

Looking through other community posts it looks like this may not available out-of-the-box. If you have Scriptrunner installed you will have additional JQL options but have a look through this post as it gives a few suggestions.

I cannot check these for you as my JQL field uses the extra options provided by apps installed in my instance which may not match what you have available.

Ragni Jayanthi_w4uieo

Thank you Kat! From the post you linked, this worked for me. I really appreciate it.

issueFunction in linkedIssuesOf("filter = '12345'", "is epic of") AND status not in (Closed, Done, Resolved, Dev)

Ragni Jayanthi_w4uieo

Thank you for the welcome Bill! The post Kat linked to below helped with what I was trying to do.

Ragni Jayanthi_w4uieo

Update:

This worked: issueFunction in linkedIssuesOf("filter = '123456'", "is epic of") AND status not in (Closed, Done, Resolved, Dev)

badrinathm

I try to do this but I get the error "Could not find any issue link type having either inward or outward description : is epic of" Remove argument to search all link types ...etc