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

[Ragni Jayanthi]

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?

[Kat Warner · Accepted solution]

"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.

[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]

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)

[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

[Ragni Jayanthi]

Update:

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

[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

[Ragni Jayanthi]

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