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).
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 hierarchies, issue 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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.