Getting Linked Issues of a Specific Project

[Michael Burns]

I want to create an issue filter to get tickets of software projects that have a linked issue from a service project.

I've created a query to get issues within a service project with a linked issue in selected software projects, but realized I need to get the reverse information to return just the linked issue in the software project.

[Trudy Claspill]

Hello @Michael Burns 

Can you clarify your requirements?

You have issues in a Service project. Are you limiting your query to just one Service project.

The Service issues are linked to issues in 1..n Software projects.

Are you wanting to get all Software issues that are linked to any issue in the Service project? Or are you wanting to get all Software issues that are linked to a subset of issues in the Service project?

Do you have any third party apps that extend JQL capabilities? 

Can you show us the query you have so far?

[Michael Burns]

Current query I have below, and I'm not using any third party apps - which returns issues of 3 different service projects, with a linked issue.I want the to get issues in software projects (CV, TRR, & TMS) that have a linked issue in service projects (RS, RHV, TMSHELP).

JQL

project in (RS, RHV, TMSHELP) and issueLinkType IS NOT EMPTY ORDER BY created DESC

[Michael Burns]

[Trudy Claspill]

Hello @Michael Burns 

You will not be able to achieve your goal in a JQL filter without a third party app.

What you need is something like this:

project in (CV, TRR, TMS) and issueLinkType IS NOT EMPTY and

issue in onlyLinkendIssueOf(project in (RS, RHV, TMSHELP) and issueLinkType IS NOT EMPTY)

ORDER BY created DESC

The first part says to get issues from the three software projects that have links.

The fictional onlyLinkedIssuesOf is a function that would look at all the issues in the three Service projects that have linked issues, and return a list of the issues that are linked to them.

The "and issue in" in between would join the two list of issues would result in giving you issues from the Software projects that are linked to the issues in the Service projects.

Jira doesn't have the fictional onlyLinkedIssuesOf function nor any comparable function that would allow you to use a filter to dynamically get a list of issue, and use that as input to get other issues (the linked issues). But there are third party apps that do.

[Charlotte Santos -Appfire-]

Hi @Michael Burns 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all issues from projects CV, TRR, and TMS that are linked to issues in projects RS, RHV and TMSHELP:

issue in linkedIssuesOfQuery("project in (RS, RHV, TMSHELP)") AND project in (CV, TRR, TMS)

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Amay Purohit_RVS]

Hi @Michael Burns  

If you would be interested in an add-on to get linked issues across projects, you can try out our plugin.

Issue Hierarchy 

The app shows your hierarchy in a tree format and  also provides sum up at each level for time estimates and story points to track your project progress.

We have multiple filter options and also ability to use jql for child issues as shown in the screen below.

(Disclaimer: I work on RVS, the vendor for this app)

[Hannes Obweger - JXL for Jira]

Hi @Michael Burns

as suggested above, this will probably require additional tooling. If you're open to solutions from the Atlassian Marketplace, your use case would be easy to solve using 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 so-called smart columns that aren’t natively available, including linked issues, along with many other issue-link-related columns. As you can apply text filtering (including logical operators like OR) to all your columns, you can perform a search like e.g. this in just a couple of clicks:

JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, you can also model much more sophisticated queries, e.g. based on the project type of your linked issues (like "Software", or "Service Management"), if that's something you might be after.

Any questions just let me know,

Best,

Hannes