Filtering for stories within specific epics

[Logan Cummins]

Hi, I'm looking to filter for all stories in a certain project, but within only certain epics.  Specifically we have a field in our Epics that is a dropdown menu "Capitalizable" and the drop down is "Yes" or "No."  I want to return results for stories, bugs, tasks, spikes that are in Epics that have the "Yes" dropdown option selected within their parent epics.  There is yet another filed within these stories, bugs, spikes that designates "non-capitalizable" and I'm trying to query for those stories that do not have any of the checkboxes selected for that field.  So if I can put this into finals words that (hopefully) makes sense, I want to find all the stories, bugs, spikes in Capitalizable Epics that have not had any of the non-capitalizable checkboxes checked yet.

So far I have this query, but it isn't returning what I want since I'm not sure how to search just within certain Epics:

project = SpareFoot and issuetype in(Spike, Bug, Story) OR project = SpareFoot and labels in(Technical_Debt, tech_debt, technical-debt, tech_debt) AND "Non-Capitalizable Activity[Checkboxes]" is EMPTY

how do I modify this to include only the stories that are within the Capitalizable Epics? (Epics that have the dropdown field "Capitalizable" = Yes

[mauricio.groth]

Hi @Logan Cummins 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the stories that are within the Capitalizable Epics

issue in childrenOfEpicsInQuery("Capitalizable = Yes") and type = story

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Mark Segall]

Hi @Logan Cummins and welcome to the community!

Unfortunately, you've hit upon a JQL limitation.  Being able to simultaneously perform a "join" type query where you're simultaneously performing a query against epics and their children is not possible natively.  There are marketplace Apps that can achieve this.

You can explicitly set which epics you want in/out of scope for the query.  It would look something like this:

(project = SpareFoot and issuetype in(Spike, Bug, Story)) OR (project = SpareFoot and labels in(Technical_Debt, tech_debt, technical-debt, tech_debt)) AND "Non-Capitalizable Activity[Checkboxes]" is EMPTY AND "Epic Link" IN (ABC-123,ABC-234,ABC-345)