Can I create a query that will find tasks where their parent epics have a common value.

[cschne41]

I am looking for a query that can find tasks that have a common text string in the summary across multiple different epics. I want to only pull from the epics in that project that have a specific value in a custome field. 

Example

Project - P

Task - T ("T" in summary for all similar tasks across various epics)

Epic custom value - V

In project P, I want to find all tasks T that belong to epics where custom value V ~"A"

[Trudy Claspill]

Hello @cschne41 

Welcome to the Atlassian community.

That is not possible if you have only native Jira filtering capabilities.

There are several third party apps that extend the filtering capabilities which would enable you to construct that filter. Are you open to obtaining an app to satisfy your requirement?

My personal favorite is Enhanced Search for Jira Cloud, but there are several others that provide similar functionality. Here is a search to help you find some:

https://marketplace.atlassian.com/search?query=jql+for+jira&hosting=cloud

[yqiao]

I think we might can achieve this by 2 queries:

Step	JQL Example
1	project = P AND issuetype = Epic AND "Epic custom value" ~ "A"
2	project = P AND issuetype = Task AND summary ~ "T" AND "Epic Link" in (EPIC-1, EPIC-2, ...)

[Marc -Devoteam-]

Hi @cschne41 and @yqiao 

I think you can to it like this as well.

In filter 2: project = P AND issuetype = Task AND summary ~ "T" AND filter = <id of filter 1>

So as example : project = P AND issuetype = Task AND summary ~ "T" AND filter = 10001

[Trudy Claspill]

@cschne41 

@yqiao solution will work but will require you to run filter one to get a list of the Epics and then paste the issue ids from that filter into filter 2. You cannot have a single filter that will dynamically determine the Epics you want and also in the same filter dynamically get the children of those Epics.

Also, in yqiao's filter 2 you should change "Epic Link" to "Parent" because the Epic Link field has been deprecated in favor of the Parent field.

@Marc -Devoteam- 

Your suggestion will not work. Filter 1 is selecting Epics. You version of filter 2 says give me issues that are in Project P, are Tasks, have a matching summary, and are in filter 2 which contains only Epics. "and filter = filter1" does not produce "and are children of the issues from filter1"