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

Search for all the stories for a list of epics

Puneet Sharma

project = PL AND issuetype = Epic AND fixVersion = "RNO - WA - Predictive Auto" ORDER BY issuetype DESC, key ASC

This is my search query for all the epics related to an initiative. I want to search for bunch of stories that are child of these epics and have a label of "iPub". I tried using Parent and "Epic Link" but both of them are giving me error. Here is my modified query

parent in (PL AND issuetype = Epic AND fixVersion = "RNO - WA - Predictive Auto" ) ORDER BY issuetype DESC, key ASC

And this is the error that I am getting
Error in the JQL Query: Expecting ')' but got 'AND'. (line 1, character 15)

Accepted answers

All comments

Reshma Begum {Appfire}

Hi @Puneet Sharma ,

If you have the list of Epic Id's, then you can use the below JQL to fetch all child stories of that Epic.

project = test1 AND parentEpic = TES-3 AND type = Story

Hope it helps!

Thanks,

Reshma

Puneet Sharma

I don't want to type all the epic ids as there are 36 epics. That's why I was trying to use the ParentEpic IN operator like this:

parentEpic IN (project = PL AND issuetype = Epic AND fixVersion = "RNO - WA - Predictive Auto" )

which is giving error to me.

Reshma Begum {Appfire}

Hi @Puneet Sharma ,

As every story created from a Epic has Epic link, you can search using the below JQL.

project = test1 AND type = Story AND "Epic Link" is not EMPTY

Hope it helps!

Thanks,

Reshma

Jack Nolddor [Sweet Bananas]

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:

1) A bunch of Epics

project = PL AND issuetype = Epic AND fixVersion = "RNO - WA - Predictive Auto"

2) Find all tasks (Tasks, Stories,...) under a given Epics

issue IN issuesInEpics(' project = PL AND issuetype = Epic AND fixVersion = "RNO - WA - Predictive Auto"  ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

Regards

Bill Sheboy

Hi @Puneet Sharma -- Welcome to the Atlassian Community!

You cannot do this type of nested query with out-of-the-box JIRA. If you have one of the scripting add-on products from the marketplace, it is possible.

As a work-around you can:

Run a query to get your epic list
Export that result list
Grab just the keys, and convert them into comma-separated values (CSV) using a text editor
Paste the CSV epic list into your second query:

"Epic Link" IN (yourCSVlist) AND labels = iPub ORDER BY "Epic Link", Key

Best regards,

Bill

Inayat Nahvi

@Puneet Sharma , to follow up on what @Reshma Begum {Appfire} suggested, maybe include the label in you JQL to narrow it down further.

project = test1 AND type = Story AND "Epic Link" is not EMPTY AND labels = iPub ORDER BY "Epic Link" ASC

Then, include Epic Link in your filter columns, and sort on Epic Link. Hope this also helps.

Smita Bhatnagar_ecg9ha

Hi Bill,

I am trying your way but am getting the error "The operator 'in' is not supported by the 'Epic Link' field. "

Thanks

Smita

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-software