Versions Compared

Old Version 11

changes.mady.by.user Jack Nolddor

Saved on

compared with

New Version Current

changes.mady.by.user Jack Nolddor

Saved on

Key

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

Description:

Excerpt

Searches issues linked to the given subquery. Additionally you can further refine your query by specifying a link type.

Note:
Since you need to enclose the provided subquery using doble quotes, you must to escape any doble quotes using in the subquery by preceding a backslash after the double quotes, alternatively you can use a single quote in some cases.

Expand
titleLet's see an example...


Panel

(error) This will not work

Code Block
languagesql
themeConfluence
issue IN linkedIssuesOf("status = "Under Review" and type = Bug")

Searches issues linked to Bug that are currently being reviewing



(tick) This will work perfectly

Code Block
languagesql
themeConfluence
issue IN linkedIssuesOf("status = \"Under Review\" and type = Bug")

Searches issues linked to Bug that are currently being reviewing

Code Block
languagesql
themeConfluence
issue IN linkedIssuesOf("status = 'Under Review' and type = Bug")

Searches issues linked to Bug that are currently being reviewing




Syntax

linkedIssuesOf(subquery)
linkedIssuesOf(subquery, link)

Where 'link' can also be any of the existing system links:
'is Epic of', 'has Epic', 'jira_subtask_inward' and 'jira_subtask_outward'

Available sincev1.8.0-RELEASE
Supported fieldsIssue
Supported operatorsIN , NOT IN
Unsupported operators

= , != , ~ , !~ , > , >= , < , <=

IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find issues linked to 'Open' Bugs:

Code Block
languagesql
themeConfluence
issue IN linkedIssuesOf("type = Bug AND status = Open")


• Find 'In Progress' issues blocked by unresolved Impediments

Code Block
languagesql
themeConfluence
status = "In Progress" AND issue IN linkedIssuesOf("type = Impediment AND resolution IS EMPTY", "blocks")

• Find issues (excl. subtask) on EMEA project linked to any Requirement

Code Block
languagesql
themeConfluence
project = EMEA AND issue IN linkedIssuesOf("type = Requirement") AND issuetype NOT IN subtasksOf("type = Requirement"subTaskIssueTypes()

Real World Use Cases:

· JRASERVER-25640 - JQL function for showing all issues linked to any issue by a given issue link type (by Chris Mountford)
· JQL query to see all Tests which are linked to all Stories in current Sprint (by SchuriiK at ATLASSIAN Community)
· JQL Query Assistance - Linked Issues (by jprentice at ATLASSIAN Community)




JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2