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

Fancy Footwork and Nested Selects in JQL

RAVI AMBAR RAO

Hi Everyone -

I've got a project called my_epics that has all my epics. And, I've got a query that returns all the epics I'm interested in

(project = my_epics and Size is "Large" and Labels = "Cool_Epics")

Now I'd like a query to return the children of those epics. In my day we would have called this a nested select

Issuetype = Story and epic_link in ( select (project = my_epics and Size is "Large" and Labels = "Cool_Epics"))

Is this possible to create in JQL?

Thanks,

Ravi

Accepted answers

Suvarna Gaikwad_3o435r

hi @RAVI AMBAR RAO

If you have a scriptrunner, it can be achieved with below query

issueFunction in issuesInEpics("project = my_epics and Size is 'Large' and Labels = 'Cool_Epics'")

Hope this helps!

All comments

Suvarna Gaikwad_3o435r

hi @RAVI AMBAR RAO

If you have a scriptrunner, it can be achieved with below query

issueFunction in issuesInEpics("project = my_epics and Size is 'Large' and Labels = 'Cool_Epics'")

Hope this helps!

RAVI AMBAR RAO

Thanks @Suvarna Gaikwad !

I'm almost afraid to ask because I think know the answer. Script runner costs money. Is there a way to do this in JIRA without purchasing any add ins?

Suvarna Gaikwad_3o435r

@RAVI AMBAR RAO I am afraid I have not seen nested jql queries that are available out of the box. we will have to use plugins like scriptrunner or jql booster pack