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

Question

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"

Thiago Wenceslau -Appfire- · Answer

Hi @cschne41

I’m Thiago, a support engineer at Appfire and I’m here to help you.

If you are considering a third-party-app, with JQL Search Extensions you can use the following query:

issue in childrenOfEpicsInQuery("project = 'P' AND Epic custom value ~ 'A'") AND issueType = "Task" AND summary ~ "T"

Just remember to change the fields to match your projects.
Also, inside queries must be enclosed in single quotes 'Example'

Please contact our support if you have any other questions about this.

Best regards, Appfire support team.

Trudy P Claspill · Answer

@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"

Marc -Devoteam- · Answer

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