JQL Tricks plugin enhances the search functionality in Jira Cloud by adding a set of useful JQL aliases that can be used in JQL queries. These aliases are similar to the standard JQL fields in Jira and duplicates the functionality of complex JQL functions in the Jira DC version.
The plugin offers the aliases under the namespace jqlt and provides an intuitive way of using the functions in Jira's advanced searching. These aliases are first class citizens in Jira and can be used in filters, dashboards, rapid boards etc. You can simply start typing jqlt to get a list of available functions, as shown below.
Following are the full list of aliases along with their syntax and examples.
Affects Versions Aliases
Fix Version Aliases
These are JQL aliases used to search issues based on the issue links and starts with jqlt.links. Following is the full list of link aliases, along with examples.
jqlt.links.count [Operator] [number]
Alias to find issues based on the number of links.
jqlt.fixversions.startedOn = "2021-01-06" - Returns all issues that has at least one fix version that started on 2021-01-06
jqlt.fixversions.startedOn > -3w - Returns all issues that has at least one fix version that started in the last 3 weeks
jqlt.fixversions.overdue [Operator] [true/false]
Alias to find issues with at least one overdue fix version.
Supported Operators : "=", "!="
jqlt.fixversions.overdue = "true" - Returns all issues with at least one overdue fix version
jqlt.fixversions.overdue = "false" - Returns all issues that do not have any overdue fix version
These are JQL aliases used to search issues based on their Epic data and Epics based on their issue data. These aliases starts with jqlt.agile. Following is the full list of agile aliases, along with examples.
jqlt.agile.issueCount [Operator] [number]
Alias to find Epics with a given number of issues under it.