Linked issues of TASKS in EPIC

[Big Jim]

Sorry for the confusing title but I'm really stuck ! 

• We have defined EPICS for tests we plan to perform (e.g. OVERALL PRODUCTION TEST)
• We then have an issue type TEST in which we define the individual tests in the EPIC (e.g. PRODUCTION TEST 1, PRODUCTION TEST 2 etc.)
• During tests we identify BUGS which are linked manually to one or more TESTS. There is no link from BUGS to the EPIC.

I need to report all BUGS linked to single EPIC e.g. OVERALL PRODUCTION TEST. 

The only way I've found to do this is to use the EPICS Links Hierarchy, export to excel and one tab lists a single entry for each individual issue type (even if this issue is linked to multiple tests). I filter for BUGS. This is a pain to put together weekly for all EPICS so I was looking for a query that could provide the same info. Any ideas ?

[Big Jim · Accepted solution]

Thanks Radek. In fact in the end I used linked issues with a filter :

issuefunction in linkedIssuesOf("filter = 'Production Report'") AND issuetype = Bug AND status != Done

[Big Jim]

Hi

I've been trying this out all morning and found the following solution : 

issueFunction in linkedIssuesOf("project = XXX AND issuetype = 'TEST' AND 'Epic Link' = YYY-86 ") AND issuetype = Bug

So this lists all Bugs linked to all issue types TEST included in EPIC number 86. 

HOWEVER !!! Now I've found that some users have linked bugs the EPIC. I'm not sure how to extend the above query to also include Bugs linked to the (same) EPIC ? 

[Radek Dostál]

If I understood the last note correctly, to include issues directly linked to the Epic it might look similar to:

issueFunction in linkedIssuesOf('key = YYY-86') AND issueType = Bug

Connecting this to your current query via OR (so that it's inclusive):

(issueFunction in linkedIssuesOf('project = "XXX" AND issuetype = TEST AND "Epic Link" = YYY-86') OR issueFunction in linkedIssuesOf('key = YYY-86')) AND issueType = Bug

//fyi not tested - just theory