Creating filter to display bugs / stories with a linked issue from Service Desk Project

[Rob_N]

Hi...

Looking for some advice here...

Currently utilising JIRA cloud to run Service Desk and Software projects.

I want to create a Filter that displays all Bugs & Stories that are created in one software project that have a linked issue that resides in another Service Desk project. (have multiple Service desk projects)

For example I can create query to simply show all bugs & stories that have a linked issue using the following jquery however I want to further define which project I want to the linked issue to come from

project = GSA AND IssueType in (Story, Bug) AND issueLinkType in (blocks, causes, relates) AND resolution = Unresolved ORDER BY created DESC

Any idea on correct syntax to use?

[Muhammad Ramzan_Atlassian Certified Master_]

You can use any third party plugin like  JQL Search Extensions for Jira & reports  its available for cloud and server both

Following query will get all issues linked with the project "projecta", you can manulplte it with further parameters by adding issuetypes etc...

linksIssueProject= projecta

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-LinksIssueProject

[Lenin Raj]

Hi @Rob_N 

You can filter for one particular linked issue using https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()

For project level filter, I found an addon that can do it: https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=cloud&tab=overview

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-LinksIssueProject

linksIssueProject= JQL

[Rob_N]

I was hoping to be able to perform this query without an extension...

Is this the only option?

[Thomas Magny-Garcia]

Hi @Rob_N 

I think you will need an extension to do what you want.

The native query doesn't not allow to search two query in the same time, what is what you want: a query to show all issues that have a link (what you did) and a query to filter the linked project.

That's why I think you will need an extension...
Hope it helps !