JQL for epics and the linked Tasks

Frank Lohfeld_ytv8pt

Hello,

I'm search a JQL expression. that find every EPIC with a special value. And all Tasks, that assigned to this Epics.
The special EPIC Attribute is named "DTCS" and the value i search is "yes" (Checkbox)

I start with 

type = Epic AND DTCS = Yes

This found the needed Epics - but how i can determine the issues linked to this epic in only one JQL

 (type = Epic AND Workstream = Yes) and (type=task and "Epic Link" has DTCS=yes )

 

Ste Wright

Hi @Frank Lohfeld

This isn't possible using standard JQL - when searching for issues within an Epic (via Epic Link) it's only one specific Epic you can search by.

Now you could in theory:

1. Search for all the Epics which have DTCS checked "Yes"
2. Export this list of Epics
3. Create a search query based on the list of Epic's issue keys which changes them from a list to a comma-separated row (I use CONCAT to do this) - i.e KEY-1, KEY-2, KEY-3, etc
4. Enter a new search based on "Epic Link" in (), where the row of keys goes into the brackets
5. Join the two queries together, i.e issuetype = Epic and DTCS = Yes or "Epic Link" in (KEY-1, KEY-2, KEY-3)

^ This is a little clunky though, as you'd have to add to the list of keys each time a new Epic is created where DTCS is checked. You could keep a track of this using a filter also to check each day - i.e issuetype = Epic and DTCS = Yes ORDER BY createdDate DESC - but it's still not ideal.

Alternative:

The alternative is to get an app which provides more powerful JQL functions - such as ScriptRunner or JQL Booster Pack which allow you to have sub-queries within your search functions.

Both of these have a function "issuesinEpics" - for example using ScriptRunner, you could use:

issueFunction in issuesInEpics("DTCS = Yes")

^ This would give you a list of all issues which are within any Epic where DTCS is checked. It's a much simpler, more automated method of the above.

Ste