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; } } }

Intersections of labels from two projects with JQL

Marko Majkic_dowot5

Is it possible to get the intersection of labels of two projects, A and B, where the Key of A is known - I need all issues of B where the intersection exists. Something like:

A.Key=KEY-123 and A.labels intersect B.labels

disclaimer: I know that this doesn't work. I used it just to show what would I want to achieve.

Thanks.

Accepted answers

Ravi Sagar _Sparxsys_

Hi @Marko Majkic

I also wish if JQL could do inner joins

JQL consists of multiple queries and each query returns issues.

Try some of these apps for improving the JQL search.

Ravi

All comments

Ravi Sagar _Sparxsys_

Hi @Marko Majkic

I also wish if JQL could do inner joins

JQL consists of multiple queries and each query returns issues.

Try some of these apps for improving the JQL search.

Ravi

Bill Sheboy

Hi @Marko Majkic

Yes, and...to Ravi's suggestion: if you need this type of query often check for marketplace JQL app addons.

If you need this one time, consider exporting the issues from the projects to a spreadsheet and join there.

If you need this multiple times for this defined use case/join, and expect the result set to be less than 100 issues, you can create an automation rule to return the issues by building the query dynamically.

Kind regards,
Bill

Marko Majkic_dowot5

Thanks, @Bill Sheboy @Ravi Sagar _Sparxsys_ . It is a little bit frustrating that most of answers to the most of a little bit more complex questions are either workarounds, like downloads and processing outside Jira, or using some of the paid marketplace solutions.

I've been using Jira (and all Atlassian products) for more than 15 years and have been a true fan all the time, but lately (last few years) they turned their products into empty shells without true innovations. Changes they are making are more annoying for the users than helping us.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud