Get Linked Tickets

[George Mitsiou]

Hello All,

I have create a discovery project named "My_Discovery" and all lot of ideas have been created in it. (Idea 1, Idea 2,....etc)

The most ideas have linked delivery tickets from other projects (Project A, Project B, ..., etc)

I want to create a JQL query in order to get the linked tickets only from Project A and Project B that are linked with any idea which exists in my discovery project named "My_Discovery" 

Any idea?

[Bill Sheboy]

Hi @George Mitsiou -- Welcome to the Atlassian Community!

Do you have any marketplace addons which enhance the features of JQL?  If not, you have some limitations for what you can find for this scenario.

For example...

Let's assume you only use the "Implements" link type for your Jira Product Discovery (JPD) items.  In that case, you could find the issues like this:

project IN (projectA, projectB)
 AND issueLinkType = "Implements"
 ORDER BY project ASC, key ASC

If you are using that link type for other things, you could narrow this down by specifically listing the relevant ideas:

project IN (projectA, projectB)
 AND (   issue IN linkedIssues(idea-1, "Is Implemented By")
      OR issue IN linkedIssues(idea-2, "Is Implemented By") )
 ORDER BY project ASC, key ASC

To learn more about these built-in features of JQL, please look here: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

If you have marketplace options that extend JQL, you may be able perform queries with joins to make these easier and more generic.

Kind regards,
Bill

[George Mitsiou]

Thanks Bill for your reply, but these delivery tickets there is a possibility to implements h other projects except my ideas of my discovery project named "My_Discovery".

for example, in projectA there are a lot of tickets that some of them implements my ideas and other implements other tickets.

The point is not to be based on implements but on implements my ideas. How can I get them?

[Bill Sheboy]

Without an addon for JQL, you would need to list each idea's key as I showed in the second example.

[George Mitsiou]

@Bill Sheboy so i should specify every idea id in the query, right ?

I am asking because there are a lot of ideas and it it not to specify one by one.

[Bill Sheboy]

If you need this one time, you could build the query in steps:

• run a query to find the ideas you care about
• export the results to a spreadsheet
• grab the keys only, and paste in a text editor
• use text functions to clone the needed JQL logic (you may need a regular expression for this)
• combine it all together, and run that query in Jira

If instead you need to do this type of query often, investigating an addon from the marketplace would be better.

[RVS_Support]

Hi @George Mitsiou 

If you are fine to try out a mktplace app you can have a look at the one we have built for the same use case.

Issue Hierarchy Reports 

You can view your cross projects linked issues and also the app is very flexible and you can use custom JQL for top level issues and a different JQL for linked issues. 

The app is free upto 10 users. Do try it out.

Disclaimer : I am part of the team which developed this app

[Hannes Obweger - JXL for Jira]

HI @George Mitsiou

just to expand on Bill's great answer: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies. These issue hierarchies can be based on Jira's built-in parent/child relationships (like task/sub-task), or based on issue links. With this, you can build a view like the one below in just a couple of clicks:

As you can see above, you can work on your issues directly in JXL, but you can also trigger various operations in Jira (e.g., store your particular list of issues as a JQL query/filter), or export your issues with just one click.

Any questions just let me know,

Best,

Hannes