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

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

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

Thanks!

2 answers

1 vote

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.