Need to pull issues where linked issues include a project type

[Conor O'Flaherty]

Trying to execute a JQL where tasks that have a certain project type linked to them are returned, removing any tasks without a 'Platform Delivery' project related in the return 

Trying below - 

issuetype = Task and linkedIssue in ("Project = 'Platform Delivery'")

*The issue key 'PROJECT = 'PLATFORM DELIVERY'' for field 'linkedIssue' is invalid.

Is their any way this can be done? 

[Trudy Claspill · Accepted solution]

Hello @Conor O'Flaherty 

Welcome to the community.

There is not a way to do what you want with native Jira functionality. You would need a third party app that extends JQL capabilities with regard to linked issues.

The function you tried to use is expecting a single issue key as the parameter. You cannot provide a filter instead to get linked issues for multiple source issues. Refer to:

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

Are you open to paying for a third party app to help you get what you want?

[Conor O'Flaherty]

Thanks @Trudy Claspill , it's not too high up on the agenda and can work around it, thanks anyway though! 

[mauricio.groth]

Hi @Conor O'Flaherty 

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

 For example, you can use this query to find tasks that are linked with issues from project Platform Delivery

issue in linkedIssuesOfQuery("project='Platform Delivery'”) and issuetype = Task

 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