Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

linkedIssuesOf(subquery) #Output: Issue list

UI Expand

title	Examples

issuetypeTaskpriorityBlocker that are linked to a Task with priority set to Blockerproject"ExampleProject" assigneej.carrey an issue that belongs to the Example Project's project and whose assignee is j.carrey.

Parser expression

Description

Code Block

language

bash

linenumbers	true

issue in linkedIssuesOf('

project = "Asset

Management" and

type = "

Employee"')

This example returns all issues

linked to the Employees tracked in the Asset Management project.

Code Block

language	bash
linenumbers	true

issue in linkedIssuesOf('

issuetype =

Task

and

priority =

"Blocker"')

This example returns all issues that are linked to

a Task with priority set to Blocker.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

subquery

Status

subtle	true
title	text

A JQL query to select the issues that are linked to the returned issues.

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns an

Status


subtle	true
title	issue list

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

linkedIssuesOf(subquery, linkTypes) #Output: Issue list

UI Expand

title	Examples

bashissuetypeTaskpriorityBlocker is blocked by, causes issues whose link type is either is blocked by or causes, and they are linked to a Task with priority set to Blocker.

vs.

This example returns all issues linked to a Blocker task either by the "is blocked by" or "causes" link type.

project"DEV"assigneej.carreyrelates to 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.

vs.

This example returns all issues linked to any DEV issue assigned to j.carrey via the "relates to

Parser expression

Description

Code Block

language

linenumbers	true

issue in linkedIssuesOf('

project =

"Asset Management" and

type = "

Employee"',

has asset")

This example returns all assets linked to the Employees via the "has asset" relationship tracked in the Asset Management project.

Code Block

language	bash

linenumbers	true

issue in linkedIssuesOf('

issuetype =

Task and

priority =

"Blocker"', "

is blocked by, causes")

This example returns all

issues linked to a Blocker task either by the "is blocked by" or "causes" link type.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

subquery

Status

subtle	true
title	text

A JQL query to select the issues that are linked to the returned issues.

UI Text Box

type	tip

linkTypes

Status

subtle	true
title	text

The link type or link types that the returned issues should have. The list of link types should be a comma-separated list.

UI Expand

title	Output

This function returns an

Status


subtle	true
title	issue list

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

Imagine the following example:

Image Removed

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.

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

issue in linkedIssuesOf('project = "Asset Management" and type = "Employee"',"has asset",1)

This example returns all assets linked to Employees tracked in the Asset Management project via the "has asset" relationship, where the Employee has at least two assets linked to.

UI Text Box

type	tip

issuetypeTaskpriorityBlockeris blocked by, causes", 2) 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 where more than 2 issues are linked to the same issue will be returned

Parser expression

Description

Code Block

language

bash

Code Block

linenumbers	true

issue in linkedIssuesOf('

project = "Asset

Management" and

type = "

PC"',"belongs to"

,2) AND type = "Employee"

This example returns all

Employees that have a PC associated within the Asset Management project, that is also associated with another person.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

subquery

Status

subtle	true
title	text

A JQL query to select the issues that are linked to the returned issues.

UI Text Box

type	tip

linkTypes

Status

subtle	true
title	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

Status


subtle	true
title	Number

A natural number larger than 0.

UI Expand

title	Output

This function returns an

Status


subtle	true
title	issue list

Include Page

	DECADIS:_snip_limit_JQL_functions
	DECADIS:_snip_limit_JQL_functions

Page properties

hidden	true

Short description

Searches for linked issues with a given subquery.

Output

Status


subtle	true
title	ISSUE LIST

Label

Page properties

hidden	true

Status

Tech review

Status

colour	Yellow
title	Ready for review

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Content

Space Tools

Versions Compared

Old Version 20

New Version 21

Key