nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter with results from 2 projects side-by-side

Alain Beaulieu_079zvh

Hi,

We have a JSM project and a standard Kanban company-managed Jira project. When a JSM issue needs higher level support, we create a corresponding issue in the Jira project and we link the two together ("Relates To").

One user asked me (I'm Jira admin) to create a filter that would return a list of issues from the JSM project having a link to an issue in the Jira project, and show it this way:

We have ScriptRunner and I'm familiar with issueFunction in linkedIssuesOf, but I don't think it will be possible to have a filter with data from two different projects on the same line. This would be trivial in SQL but in JQL?

Anyone would know by any chance?

Accepted answers

All comments

Nikola Perisic

Hi @Alain Beaulieu

You can use something like:

project in ("Advanced IT Service","Customer Support")

Replace the project names in quotes with your project name. That with the combination of: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/ where you would look for linkedissues() function.

Mohamed Benziane

Hi,

You're right; you won’t be able to display information from multiple issues in one line unless all the info is consolidated into a single ticket.

You could try using the Jira Cloud app in Excel to pull data, which would allow you to work with the values directly in Excel.

Alain Beaulieu_079zvh

Thanks @Nikola Perisic but that's not the issue. The issue is the filter columns returned. How can you show the keys/ids of the issues from both projects side by side in the results? Plus the statuses, plus the respective Assigned To?

If my JQL function has key in it, which project does it come from?

In SQL I would write SELECT JSM.key, Jira.key, JSM.Status, Jira.Status... etc.

I don't know how to have the keys, statuses, assigned to values from both projects returned on the same line. I don't think it's possible but I'm hoping someone would have a magic trick.

Alain Beaulieu_079zvh

Thanks @Mohamed Benziane . I'm not familiar with that Excel plugin but I can have a look.

Nikola Perisic

JQL is not based on SQL even though it has some similarities. But the results are being shown in the format of issues. In Data Center you can use SQL since its hosted on own database by you, and you can show the data like you've just described. With JQL in cloud, this works only based on the issue search results.

Alain Beaulieu_079zvh

Right.

Hannes Obweger - JXL for Jira

Hi @Alain Beaulieu

if you're open to solutions from the Atlassian Marketplace, you'd get pretty close 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 range 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 epic/story), and/or based on issue links of configurable issue link types.

With this, you can build a cross-JSM-JSWM like e.g. this in just a couple of clicks:

In this case, the JSW tickets (bugs) are connected to their parent JSM tickets via issue links of type relates to.

Custom issue hierarchies also play well with JXL's other advanced features, such as issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Alain Beaulieu_079zvh

Hello @Hannes Obweger - JXL for Jira,

Of course I'm always open to plugins, we already use a good dozen. But I've been diplomatically informed by higher management that we will not purchase any other Jira plugin for the time being.

That being said, your product looks very interesting and powerful. I will certainly keep a shortcut to it in my notes. Eventually, we never know. And I think the use case would be easy to make.

Thanks for sharing!

Alain Beaulieu_079zvh

@Hannes Obweger - JXL for Jira , I'm curious. I'm guessing the table you showed is based on some sort of query. I can clearly see the hierarchy you mentioned. How would you write that query and is it in JQL?

Hannes Obweger - JXL for Jira

Hi @Alain Beaulieu

yes, every sheet is based on either a JQL statement or a saved filter (the sheet scope). For your use case, we'd need a query that pulls in the relevant JSM issues, and the linked JSW issues. (It's not a big deal if we pull in some additional issues, as we can filter them out in JXL.) JXL will then sort out the hierarchy between the issues based on your configured hierarchy (the so-called structure) and display them accordingly.

If you're interested, you can see JXL in action here.

Best,

Hannes

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

cloud

jira-cloud

jql

filters