JQL functions

Owned by Antonella Capalbo
Last updated: Nov 10, 2017
3 min read
The Herzum Quick Linker provides a set of useful JQL functions to filter on the tickets linked via Herzum Quick Links:
1

From the Jira menu, click Issues -> Search for Issues

Search for Issues tab

2

Click Advanced to switch the form to advance search mode using JQL.

Search screen

3

Enter the JQL function and Click the search icon to run the search.


Search screen

hqlLinkedIssues

The hqlLinkedIssues([issueLinkType], [linkVersus], [partnershipType],[issueHierarchy]) JQL function searches for all issues linking to onother issue via the specified Link Type and,when specified, by having the specified link versus. Additional, it is possible to filter issues linking issues on any remote instance and further specialize the search for source/target issues.    

The expected parameters in input are:

  • LinkType (Optional),
  • linkVersus (Optional),  it can have O (outward link type) and I (inward link type)
  • partnershipType (Optional), it can have local (local partnership) and remote ( partnership between two different Jira instances)
  • issueHierarchy (Optional), source (returns only the issue from whom the link has been created), target. 

Examples

To find all the issues on the current Jira instance blocking or blocked by issues on any remote Jira instance.

issue in hqlLinkedIssues("Blocks", "", "remote", "")

hqlLinkedIssuesOf

The hqlLinkedIssuesOf(subquery, [link type], [link versus]) JQL function searches for all issues linked at least to one issue satisfying the filter and, when specified, having the specific link type and link direction.

The search is performed on issues linked via a local partnership only.

The expected parameters in input are:

  • subquery ( Mandatory), it can have any valid JQL clause.
  • link type (Optional), 
  • link versus (Optional), it can have O (outward link type) and I (inward link type).

Examples

Assuming you have the following Issue Linking settings

and the following Mapping

Searching issues blocked by linked issues in a state not equal to Done

The JQL function  issue in hqlLinkedIssuesOf("status!=done", "Blocks", "O") will research all issues blocked by one/more issue/s not having status equal to done.

Searching issues in a state not equal to Done, blocking linked issues having priority High

The JQL function issue in hqlLinkedIssuesOf("priority= High", "Blocks", "I") and status != Done will research all issues not having status equal to Done, blocking issues having priority equal to High.