Reporting on Linked Problem Tickets

[Anna Ridley]

Hi,

I'm needing to report on how many open incidents are linked to existing Problem tickets in a particular project.

Can someone help me with the JQL please? I'm lost with this now and probably missing something simple!

Thanks in advance

Anna :-)

[Joseph Chung Yin]

@Anna Ridley -

Can you advise on if all the linked issues coming within the same JSM project or other JSM projects to your existing problem issues?

In addition, what link type that you are using?

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Anna Ridley]

Thanks for coming back to me so quickly!

Yes, they are in the same project which I think will help!!

The link type for the most part will be 'Caused By' 

[Joseph Chung Yin]

@Anna Ridley -

Hi Anna:

The out of box JQL functionality only provides the following function - linkedissue and linkedIssues()

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-linkedissuelinkedissue

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-linkedIssueslinkedIssues--

Which you are limited to knowing the parent link issue key.  You will need to look into add-on (i.e Script Runner for Jira - https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?tab=overview&hosting=cloud) for advanced JQL functionality.  Example - issuefunction operation to access their custom function "linkedIssuesOf" - issuefunction in linkedIssuesOf('project = projectName', 'is cloned by')  to give you the advanced JQL search capability.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[mauricio.groth]

Hi @Anna Ridley

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

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

You can use this query to find all the incidents, that are open and in the particular project that have a link to the problems

issue in linkedIssuesOfQuery("type = problem") and type = incident and status = open and project = ParticularProject

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício