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

JIRA query using output of another query

S Sheikh

Requirement -

I need to extract list of stories for a specified list of epics of a particular fixversion.

Query 1 - type=Epic and fixversion="V1" and project=ABC

Query 2 - All the stories linked to list of epics from above query -

Can I have a combined query for the above 2 queries?

Accepted answers

Gaurav_0av1h6

Hello @S Sheikh

Welcome to the community!!

For this purpose, kindly check the 'Advanced search reference JQL functions'. there are options like parentEpic(), linkedIssue, linkedIssues() which can be used to create the combination query as per requirement.

Please note that the query in query is still not natively possible, and would require a plugin.

Kindly accept the answer if this helps.

-GG

All comments

Fabio Racobaldo _Catworkx_

HI @S Sheikh ,

welcome to the Atlassian community!

Please try the following query :

issue IN issuesInEpics(' type=Epic and fixversion="V1" and project=ABC  ')

Hope this helps,

Fabio

Gaurav_0av1h6

Hello @S Sheikh

Welcome to the community!!

Please note that the query in query is still not natively possible, and would require a plugin.

Kindly accept the answer if this helps.

-GG

S Sheikh

Hi Fabio ...Many Thanks for your response.

I am not sure if the above query serves my purpose.

Let me explain the problem - I have 10 Epis and these epics have about 50 stories linked under these -Please note the stories are linked to epic using the Epic Link

I want to write a query that fetches all the stories under these epics using the fixversion of the parent epic.

Fabio Racobaldo _Catworkx_

Hi @S Sheikh , please try the provided query. It should retrieve all issues in your epic. If you need to retrieve just stories you could use :

type=Story and issue IN issuesInEpics(' type=Epic and fixversion="V1" and project=ABC  ')

Fabio

Trudy P Claspill

The specified Advanced Search functions will not fulfill the requirement. parentEpic function requires an explicit list of issue keys, and the requirement is to use a dynamically generated list of Epic issue keys.

This cannot be done without a third party app.

Trudy P Claspill

@Fabio Racobaldo _Catworkx_

issuesInEpic doesn't appear to be a native advanced search function for Jira Cloud. Are you using a third party app to get that?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud