Intersections of labels from two projects with JQL

[Marko Majkic]

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.

[Ravi Sagar _Sparxsys_ · Accepted solution]

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]

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.