How can i filter issues from a specific project with related issues from another specific project?

[Álvaro Galvez Garrido]

Is it possible to filter the issues that have an specific project related issues by JQL?
I'm trying to report the ratio of related issues from one project to another (Incident Management to Problems Management) to analyze how many incidents have resulted in a problem and how we can prevent them

[Rahul_RVS]

Hi @Álvaro Galvez Garrido 

For this requirement you can try out our plugin to track progress of issues in your cross projects Links and their status as well

Agile Tools - Epic Tree, Links Tree and Time in Status 

The add-on allows you to visualize your Links hierarchy with option to view all your custom fields on a single screen.

Key features of Links Hierarchy:

• Links Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

You get multiple other features as below in the same app

• More than 8 types of Time in Status Reports. Excel Export available for all status reports.
• Epic Hierarchy / Sum Up (Standard Jira Hierarchy Epic -> Story -> SubTask)
• Portfolio/Advanced roadmaps Hierarchy
• Worklogs Report
• Timesheet Entry screen
• Dashboard gadgets for all the reports

[Daniel Turczanski - JQL Search Extensions]

Hi @Álvaro Galvez Garrido ,

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:

linkedByIssueProject=PM AND project=IM

Check out the documentation to see more examples.

I hope this helps!

Daniel

[Trudy Claspill]

This is not possible with the native filtering functionality in Jira. There may be a third party app that provides this functionality.