Links JQL functions

The instructions on this page describe how to execute a JQL search using JQL Search Extensions.

 

Links JQL functions

JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search.

LinkedIssuesOfQuery

For a given JQL subquery and an optional link type, it finds issues linked to resulting issues.

issue in linkedIssuesOfQuery("project=ACME", "is blocked by") finds issues that my project ACME is blocked by
issue in linkedIssuesOfQuery("project=ACME", "blocks") finds issues that project ACME blocks
issue in linkedIssuesOfQuery("type=Epic AND status='To Do'") finds issues that are linked in any way with epics that are in progress

Links JQL Aliases

LinksCount

Search for issues with a particular number of links. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

 

EXAMPLES

Find issues which have links. 

1 linksCount > 0

 

LinkedBy

Search for issues that are linked by particular issues. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find issues which were linked by JQL-3 or JQL-5. 

1 linkedBy in (JQL-3, JQL-5)

 

LinksIssue

Search for issues which links a particular issue. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find issues which link JQL-3 or JQL-5

1 linksIssue in (JQL-3, JQL-5)

 

LinkType

Search for issues which have a particular link type. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are blocked by another issue

1 linkType = "is blocked by"

 

LinkedIssueStatus

Search for issues which are linked or link issues with a particular status. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are linked by issues in "To Do" status. 

1 linkedIssueStatus = "To Do"

 

LinkedIssueStatusCategory

Search for issues which are linked or link issues with a particular status category. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are linked or link issues in status category "Done"

1 linkedIssueStatusCategory = Done

 

LinkedIssueType

Search for issues which are linked or link issue with a particular issue type. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are linked by Bugs. 

1 linkedIssueType = Bug

 

LinkedIssuePriority

Search for issues which are linked or links issues with a particular priority. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are linked by high priority issues.

1 linkedIssuePriority = "High"

 

LinksIssuesCount

Search for issues which link to a particular number of issues. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

 

EXAMPLES

Find issues which link more than 5 issues.

1 linksIssuesCount > 5

 

LinkedByIssuesCount

Search for issues which are linked by a particular number of issues. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

 

EXAMPLES 

Find issues which are linked by more than 10 issues. 

1 linkedByIssueCount > 10 

 

LinkedByIssueProject

Search for issues which are linked by issues from a particular project. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which are linked by issues from project JQL

1 linkedByIssueProject = JQL

 

LinksIssueProject

Search for issues which link to issues from a particular project. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find all issues which link to issues from project JQL

1 linksIssueProject= JQL