Versions Compared

Old Version 22

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 for issues linked to remote content. That is, issues linked to web pages, Confluence pages, or any other custom remote link type that you have set up.
See also: hasRemoteLinks()



Syntax

remoteLinkedIssuesOf(searchTerm)
remoteLinkedIssuesOf(remoteLinkProperty, searchTerm)

Where 'remoteLinkProperty' can be any of the following properties:
'title', 'url', 'application' and 'relationship'
If omitted this function will try to match remote links against 'title' and 'url' properties

Where 'searchTerm' is a string representation of the given property value.
When used alone or in conjuntion with either 'title' or 'url' properties, some wildcard are allowed:
* - Matches zero or more characters
? - Matches exactly one character

Available sincev2.1.0-RELEASE
Supported fieldsIssue
Supported operatorsIN , NOT IN
Unsupported operators

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

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

Examples:

• Find all issues linked to a linked Confluence instance:

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("application", "confluence")

• Find all issues with a remote link to any Atlassian app (Confluence, JIRA, Bamboo, Bitbucket, ...):

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("application", "atlassian")

• Find issues linked to a specific Confluence page:

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("url", "*pageId=1176162")

issue IN remoteLinkedIssuesOf("*pageId=1176162")
• Find issues linked to a specific site / host:
Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("url", "*www.google.com*")

issue IN remoteLinkedIssuesOf("*www.google.com*")

• Find issues linked to a specific URL:

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("url", "https://marketplace.atlassian.com/vendors/1213300/sweet-bananas")

issue IN remoteLinkedIssuesOf("https://marketplace.atlassian.com/vendors/1213300/sweet-bananas")

• Find issues containing 'Support' word on theirs remote link titles:

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("title", "*Support*") 

issue IN remoteLinkedIssuesOf("*Support*")

• Find issues remotely linked using a given 'relationship' property:

Code Block
languagesql
themeConfluence
issue IN remoteLinkedIssuesOf("relationship", "Wiki Page") 

issue IN remoteLinkedIssuesOf("relationship", "mentioned in") 

issue IN remoteLinkedIssuesOf("relationship", "Created from build") 

issue IN remoteLinkedIssuesOf("relationship", "caused by")



(warning) Usage Warning:

While using this function, the following needs to be taken into consideration:

  • For Confluence pages the title property is stored as either 'Wiki Page' or simply 'Page' - so you can’t search on the current Confluence page title.

  • For Confluence pages the URL always follows this structure {baseURL}/pages/viewpage.action?pageId={number} - so you can’t search on the Confluence user-friendly url. You can get the pageId by clicking Edit and copying it out of Confluence. Alternatively just click through on the remote link from the JIRA issue.

  • Editing an existing Application Link's baseURL or displayURL does not update the data stored in the database for already existing links - you need to keep using the old baseURL while querying complete urls to linked applications.

Real World Use Cases:

· JRASERVER-28064 - The ability to query remote link data via JQL (by Michael Andreacchio)
· Using JQL to search for remote issue links (by Mark Terrel at ATLASSIAN Community)
· Search issues which have remote links - how to? (by TamasS at ATLASSIAN Community)


JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2