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 a first class citizen in Jira and can be used in filters, dashboards, rapid boards etc.
Follow the documentation to install and configure the plugin. See usage for syntax and examples.
Link Functions
Attachment Functions
Comment Functions
Worklog Functions
Subtask Functions
Parent Functions
History Functions
Affect Version Functions
Fix Version Functions
Agile Functions
Component Functions
Link Functions
jqlt.links.count
jqlt.links.type
jqlt.links.issue
jqlt.links.status
jqlt.links.statusCategory
jqlt.links.priority
jqlt.links.issuetype
jqlt.links.project
Attachment Functions
jqlt.attachments.count
jqlt.attachments.createdFirst
jqlt.attachments.createdLast
jqlt.attachments.createdOn
jqlt.attachments.type
jqlt.attachments.name
jqlt.attachments.author
Comment Functions
jqlt.comments.count
jqlt.comments.createdFirst
jqlt.comments.createdLast
jqlt.comments.createdOn
jqlt.comments.createdBy
jqlt.comments.updatedOn
jqlt.comments.updatedBy
Worklog Functions
jqlt.worklogs.count
jqlt.worklogs.createdFirst
jqlt.worklogs.createdLast
jqlt.worklogs.createdOn
jqlt.worklogs.createdBy
jqlt.worklogs.updatedOn
jqlt.worklogs.updatedBy
Subtask Functions
jqlt.subtasks.count
jqlt.subtasks.key
jqlt.subtasks.summary
jqlt.subtasks.status
jqlt.subtasks.statusCategory
jqlt.subtasks.priority
jqlt.subtasks.issuetype
Parent Functions
jqlt.parent.summary
jqlt.parent.status
jqlt.parent.statusCategory
jqlt.parent.priority
jqlt.parent.issuetype
History Functions
jqlt.history.field
jqlt.history.project.from
jqlt.history.project.to
jqlt.history.issuetype.from
jqlt.history.issuetype.to
jqlt.history.updatedBy
jqlt.history.lastUpdatedBy
jqlt.history.lastTransitonedBy
jqlt.history.updatedOn
Affect Version Functions
jqlt.affectsversions.count
jqlt.affectsversions.releasedCount
jqlt.affectsversions.archivedCount
jqlt.affectsversions.startedOn
jqlt.affectsversions.releasedOn
jqlt.affectsversions.overdue
Fix Version Functions
jqlt.fixversions.count
jqlt.fixversions.releasedCount
jqlt.fixversions.archivedCount
jqlt.fixversions.startedOn
jqlt.fixversions.releasedOn
jqlt.fixversions.overdue
Agile Functions
jqlt.agile.issueCount
jqlt.agile.issueKey
jqlt.agile.issueSummary
jqlt.agile.issueProject
jqlt.agile.issueType
jqlt.agile.issueStatus
jqlt.agile.issueStatusCategory
jqlt.agile.issuePriority
jqlt.agile.epicSummary
jqlt.agile.epicProject
jqlt.agile.epicStatus
jqlt.agile.epicStatusCategory
jqlt.agile.epicPriority
Component Functions
jqlt.components.count
jqlt.components.leads
Are you migrating the JQL Tricks App from Server to Cloud? Please take a look at our migration doc for more details.