JIRA JQL to get all cross team dependent tickets

[faisal khan]

I am trying to make a saved Issues filter so that I can quickly find all of my Team's tickets that have a relation to a ticket from another Team.

I have mocked up some pseudo SQL website to explain what I am trying to do in JQL. I just can't seem to figure out how to JOIN in JQL.

SELECT *
FROM [Tickets] AS A
INNER JOIN [Tickets] AS B ON A.Relatesto = B.ID
WHERE A.Team <> B.Team
AND A.Status <> 'Resolved'

[Daniel Turczanski - JQL Search Extensions]

Hi @faisal khan,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

Team="A" AND status!="Resolved" AND issue in linkedIssuesOfQuery("Team='B'", "relates to")

Check out the documentation to see more examples.

I hope this helps!

Daniel

[Rahul_RVS]

Hi @faisal khan 

If you would be interested in a ready made solution, You may want to try out our plugin,

Agile Tools : Epic Tree & Time in Status 

The plugin provides complete hierarchy of your dependent issues with their statuses and much more.

Along with this the add-on also provides Epic Hierarchy, Multiple (more than 8) Time in Status reports to track your issues and Worklogs report to track time spent each day/week/month, based multiple filters/group

[Bill Sheboy]

Hi @faisal khan -- Welcome to the Atlassian Community!

JQL is not a SQL, and so it does not support joins, aggregate functions, and other such features.  It is filtering tool to support reporting, issue selection for boards, etc.

There are marketplace apps for purchase that extend the functions of JQL which may make this possible.  If you regularly need to perform such queries, please check the marketplace: https://marketplace.atlassian.com/

If you only need to perform this query one time, consider if it would be possible to perform some JQL searches, export the results, and perform the joins and analysis in a spreadsheet.

Kind regards,
Bill