Find all tickets of users that are also working on a specific epic

[Florian Huebner]

I want to create a filter that gives me only those tickets of users who are working on a specific epic (but not only tickets of that epic).

I.e., I want to 

• find all tickets linked to an epic
• get a list of their assignees 
• find all tickets assigned to users in that list

Would be great to get help, wasn't able to figure it out!

Thanks!

[Piotr Bojko]

Check the Smart QL - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview

It allows you to mix JQL with SQL (and XPATH).

Query for your need in Smart QL is as simple as following

SELECT i.assignee, AUX.ASISSUEKEY(i.id)
FROM TABLE(AUX.JQL('assignee', '"Epic Link" = SSP-24 ')) jql
JOIN issues i ON jql.assignee = i.assignee

You can save the query as Smart QL custom view and then use is with Smart QL gadget on a dashboard. 

[Piotr Bojko]

See Smart QL docs - https://codedoers.atlassian.net/wiki/spaces/SUPPORT/pages/186712065/Getting+started+with+Smart+QL

[Andreas]

This looks too complicated for JIRAs out of the box functionalities.

Did you already take a look at Scriptrunners Enhanced Search?

Or maybe Nested JQLs using Power Scripts™ may help you out.