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.
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