Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL Query - Project X with no linked issues in Project Y

Chris Dokter
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 12, 2024

I would like to do an audit of tickets in one project (eg Project X) that have not been linked to a ticket in another project (eg Project Y).

2 answers

1 accepted

3 votes
Answer accepted
Nicolas Werle _Decadis AG_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2024

Hi @Chris Dokter , 

Unfortunately, this is not possible with standard Jira tools.
With the help of the ScriptRunner for Jira app, you could use the following JQL:
project = X AND issueFunction not in linkedIssuesOf("project = Y"). 

I hope this helps you.
With best regards, 
Nicolas

Chris Dokter
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 12, 2024

Thanks @Nicolas Werle _Decadis AG_

This helps but unfortunately I do not think I have access to the SriptRunner app for our organization. If/when I do have access, I will revisit this.

Cheers,
Chris

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 15, 2024

Hi @Chris Dokter

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do 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 advanced features, including support for (configurable) issue hierarchiesissue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to perform text filtering (with logical operators) on all issue fields and columns.

This is how it looks in action:

issue-link-filtering-v2.gif

Here, I'm filtering down to all issues that don't ("NOT") have an issue link to project JSWC. For more complex use cases, you could also use regular expressions

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events