Versions Compared

Old Version 1

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 with / without remote issue links, additionally you can further refine your query by using a number expression.
See also: remoteLinkedIssuesOf linkedIssuesOf() and hasRemoteLinks()

Note:

A 'number expression' is made of an optional operator representing by its mathematical symbol and a (prositive/negative) number.

Expand
titleLet's see the allowed symbols...


OperatorSymbol
Equals to=
Not equals to!=
Greater than>
Greater than or equals to>=
Less than<
Less than or equals to<=


(warning) By default, this function only includes issues with at least one remote link even if you use the '<' or '<=' operator.
   You must explicity add 'issues NOT IN hasRemoteLinks()' clause to your query, if you also want to search for issues without remote links.


Syntax

hasRemoteLinkshasLinks()
hasLinks(numberExpression)
hasRemoteLinkshasLinks(numberExpression, linkDescription)

Available sincev2.12.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 without remote issue links:

Code Block
languagesql
themeConfluence
issue NOT IN hasRemoteLinkshasLinks()

issue NOT IN hasRemoteLinkshasLinks("> 0")

• Find Stories that have three or more remote issue links

Code Block
languagesql
themeConfluence
type = Story AND issue IN hasRemoteLinkshasLinks(">= 3")

• Find Features that have been blocked by at least two issues

Code Block
languagesql
themeConfluence
type = Feature AND issue IN hasLinks(">= 2", "is blocked by")

• Find issues within the EMEA project having less than than 2 remote issue links or no remote no issue links at all.

Code Block
languagesql
themeConfluence
project = EMEA AND (issue IN hasRemoteLinkshasLinks("< 2") OR issue NOT IN hasRemoteLinkshasLinks())

Real World Use Cases:

· JRASERVER-28064 - The ability to query remote link data via JQL(by Michael Andreacchio25640 - JQL function for showing all issues linked to any issue by a given issue link type(by Chris Mountford)
· Using JQL to search for remote issue links (by Mark Terrel JQL query to see all Tests which are linked to all Stories in current Sprint (by SchuriiK at ATLASSIAN Community)
· Search issues which have remote links - how to? (by TamasSJQL Query Assistance - Linked Issues (by jprentice at ATLASSIAN Community)

JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2