J tricks - Little JIRA Tricks
  • Home
  • Plugins ↓
    • JQL Tricks Plugin
      • JQL Tricks Plugin - Cloud
        • JQLT Cloud Installation
        • JQLT Cloud Configuration
        • JQLT Cloud Usage
        • JQLT Cloud License
        • JQLT Cloud FAQ
      • JQL Tricks Plugin - DC
        • JQLT DC Installation
        • JQLT DC Configuration
        • JQLT DC Usage
          • JQLT Issue Functions
          • JQLT Subtask Functions
          • JQLT Links Functions
          • JQLT Development Functions
          • JQLT Worklog Functions
          • JQLT Project Functions
          • JQLT Component Functions
          • JQLT Version Functions
          • JQLT Group Functions
          • JQLT User Functions
          • JQLT Date Functions
        • JQLT DC License
        • JQLT DC FAQ
        • JQLT DC Known Issues
        • JQLT DC Performance
      • JQL Tricks Cloud Migration
    • Simplified Planner
      • J-Planner Installation
      • J-Planner Configuration
      • J-Planner Usage
        • Creating a plan
        • Editing a plan
        • Deleting a plan
        • Viewing a plan
        • Modifying a plan
      • J-Planner FAQ
    • Atla-Search Plugin
      • Atla-Search Installation
      • Atla-Search Configuration
      • Atla-Search Usage
      • Atla-Search License
      • Atla-Search FAQ
    • Copy to subtask Plugin
    • All Plugins
  • Tutorials
  • The Book
  • Contact Us
  • Home
  • Plugins ↓
    • JQL Tricks Plugin
      • JQL Tricks Plugin - Cloud
        • JQLT Cloud Installation
        • JQLT Cloud Configuration
        • JQLT Cloud Usage
        • JQLT Cloud License
        • JQLT Cloud FAQ
      • JQL Tricks Plugin - DC
        • JQLT DC Installation
        • JQLT DC Configuration
        • JQLT DC Usage
          • JQLT Issue Functions
          • JQLT Subtask Functions
          • JQLT Links Functions
          • JQLT Development Functions
          • JQLT Worklog Functions
          • JQLT Project Functions
          • JQLT Component Functions
          • JQLT Version Functions
          • JQLT Group Functions
          • JQLT User Functions
          • JQLT Date Functions
        • JQLT DC License
        • JQLT DC FAQ
        • JQLT DC Known Issues
        • JQLT DC Performance
      • JQL Tricks Cloud Migration
    • Simplified Planner
      • J-Planner Installation
      • J-Planner Configuration
      • J-Planner Usage
        • Creating a plan
        • Editing a plan
        • Deleting a plan
        • Viewing a plan
        • Modifying a plan
      • J-Planner FAQ
    • Atla-Search Plugin
      • Atla-Search Installation
      • Atla-Search Configuration
      • Atla-Search Usage
      • Atla-Search License
      • Atla-Search FAQ
    • Copy to subtask Plugin
    • All Plugins
  • Tutorials
  • The Book
  • Contact Us

JQL Tricks Plugin - Cloud

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.
Installation
Configuration
Usage
Licensing
FAQ

SUPPORT
APPS
TUTORIALS
THE BOOK
© J-Tricks