Need a Jira JQL Query to find the linked issues in the whole project tickets. Kindly help on this.
Hi Asmath,
If you have either of the ScriptRunner for Jira Cloud or the Enhanced Search for Jira plugins installed, then the linkedIssuesOf() JQL function can help to achieve your requirement.
Regards,
Kristian
Hi @Asmath Basha
To find all the issues with linked issues in a Jira project, you can use the following JQL query:
project = "YOUR_PROJECT_KEY" AND issueLinkType IS NOT EMPTY
If you want to filter by specific link types (like "blocks," "is blocked by," "relates to"), you can include the issueLinkType with a specific value, like:
issueLinkType
project = "YOUR_PROJECT_KEY" AND issueLinkType = "blocks"
By that you mean all the items having any issue link in a certain project?
By default Jira does not have many JQL functions to query for linked issues.
You can do:
More on https://support.atlassian.com/jira-service-management-cloud/docs/jql-functions/#linkedissue
I usually use scriptrunner which provides this function:
project = ABC and issuefunction in haslinks()
UPDATE:
nevermind my answer. Manoj provided a better solution.
Hi @Manoj Kumar Gangwar thanks for your reply.
In this scenario, I would you to to follow the suggestion provided by Charlie.
key IN (ISSUE-1, ISSUE-2, ISSUE-3, ...) AND statusCategory = Done
If there are too many linked issues to manually input then use the addons like Scriptrunner or JQL search extension.
Hi @Manoj Kumar Gangwar , thanks for the clarification.
if you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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. 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. Once you've set up your hierarchy, you can use JXL's various search and filtering techniques to narrow down to the issues you're interested in, like so:
There's a few things going on here - happy to elaborate if that's a direction that might be of interest to you. I should also add that issue hierarchies also play well with JXL's other advanced features, such as sum-ups, conditional formatting, or inline bulk editing via copy/paste.
Any questions just let me know,
Best,
Hannes
Hi @Charlie Misonne thanks for the clarification.
Hi @Kristian Walker _Adaptavist_ , will check in Scriptrunner also. linkedIssuesOf() function will support in Jira cloud?
Yes linkedIssuesOf() will work in Jira Cloud and the docs linked above are for Jira Cloud.
In Jira Cloud you write the queries on the Enhanced Search page instead of in the main Jira search bar.
Hi @Kristian Walker _Adaptavist_ , Can you send me the example JQL Query to achieve this using Enhanced search for Jira.
Lets all merge
It looks like you're new here. Sign in or register to get started.
