linkedIssuesOf()

This JQL function can be used to search for issues that have a certain link to issues that satisfy the JQL subquery.

Syntax

linkedIssuesOf(subquery) #Output: Issue list

Examples

Parser expression	Description
issue in linkedIssuesOf('issuetype = Task and priority = "Blocker"')	This example returns all issues that are linked to a Task with priority set to Blocker.
issue in linkedIssuesOf('project = "Example Project" and assignee = j.carrey')	This example returns all issues that are linked to an issue that belongs to the Example Project's project and whose assignee is j.carrey.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`subquery`	TEXT	A JQL query to select the issues that are linked to the returned issues. Pro tip: Write the JQL query in single quotes instead of double quotes. Otherwise everytime a double-quotation is used in the subquery, they must be jumped with a slash, just like in the previous example.

Output

This function returns a ISSUE LIST

Variant where you can additionally specify only certain link types you want to allow.

Syntax

linkedIssuesOf(subquery, linkTypes) #Output: Issue list

Examples

Parser expression	Description
issue in linkedIssuesOf('issuetype = Task and priority = "Blocker"', "is blocked by, causes")	This example returns all issues whose link type is either is blocked by or causes, and they are linked to a Task with priority set to Blocker.
issue in linkedIssuesOf('project = "Example Project" and assignee = j.carrey', "relates to")	This example returns all issues whose link type is relates to, and they are linked to an issue that belongs to the Example Project's project and whose assignee is j.carrey.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`subquery`	TEXT	A JQL query to select the issues that are linked to the returned issues. Pro tip: Write the JQL query in single quotes instead of double quotes. Otherwise everytime a double-quotation is used in the subquery, they must be jumped with a slash, just like in the previous example.
`linkTypes`	TEXT	The link type or link types that the returned issues should have. The list of link types should be a comma-separated list.

Output

This function returns a ISSUE LIST

Variant where you can additionally specify a minimum of issues that need to be linked, fulfilling the given link types.

Syntax

linkedIssuesOf(subquery, linkTypes, minimumLinked) #Output: Issue list

Imagine the following example:

The computation of that JQL would be as follows:

Grab all issues that fulfill the JQL "project = WEB" and take their linked issues → SOF-1, SOF-2, SOF-3, SOF-4, SOF-5
Only grab the issues linked with link type "blocks" → SOF-1, SOF-2, SOF-3
Only grab those issues where at least 2 issues are linked to the same issue → SOF-1, SOF-2

So the final result of that JQL would be SOF-1 and SOF-2.

Examples

Parser expression	Description
issue in linkedIssuesOf('issuetype = Task and priority = "Blocker"', "is blocked by, causes", 2)	This example returns all issues whose link type is either is blocked by or causes, and that are linked to a Task with priority set to Blocker. In addition only those issues will be returned where more than 2 issues are linked to the same issue.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`subquery`	TEXT	A JQL query to select the issues that are linked to the returned issues. Pro tip: Write the JQL query in single quotes instead of double quotes. Otherwise everytime a double-quotation is used in the subquery, they must be jumped with a slash, just like in the previous example.
`linkTypes`	TEXT	The link type or link types that the returned issues should have. The list of link types should be a comma-separated list.
`minimumLinked`	NUMBER	A positive number larger than 0.

Output

This function returns a ISSUE LIST

The result is not what you expected? The number of returned issues feels too low?

By default, the maximum number of issues that will be returned by the JQL subquery, and thus can be processed by the logical expression is 1000.

To ensure the performance of your entire Jira instance, we limit the execution of the JQL function in terms of issue count and execution time. Please refer to your admin if you need to change the configuration.

Content

Space Tools