JQL Tricks plugin enhances the search functionality in Jira Datacenter by adding a set of useful JQL Functions for JIRA 4.x+. Those include simple JQL functions to complex ones.
It has the option to limit the plugin functionality to selected groups and/or limit the individual functions to selected projects.
The plugin also introduces a JQL cache of configurable delay for better performance. The default delay is 120 seconds. Follow the documentation to install and configure the plugin.
Following are the list of functions included. Please click on the linked pages for full syntax of functions, description of the functions and sample queries.
It has the option to limit the plugin functionality to selected groups and/or limit the individual functions to selected projects.
The plugin also introduces a JQL cache of configurable delay for better performance. The default delay is 120 seconds. Follow the documentation to install and configure the plugin.
Following are the list of functions included. Please click on the linked pages for full syntax of functions, description of the functions and sample queries.
Issue Functions
Subtask Functions
Issue Link Functions
Worklog Functions
Group Functions
Version Functions
Component Functions
User Functions
Project Functions
Date Functions
Development Functions
Issue Functions
- hasAttachments([Count],[Operator])
- hasSameValues(Field1, Field2, [Field3] .. [Field n])
- commentedByUser([User])
- commentedOnDate(date)
- commentedAfterDate(date)
- commentedBeforeDate(date)
- attachedByUser([User])
- componentsFromProject(Project)
- movedIssues([type],[From],[To])
- hasSameVersions()
- hasVersions()
- hasComponents()
Subtask Functions
- parent(JqlQuery)
- subtask(JqlQuery)
- hasSubtasks([subtaskType])
Issue Link Functions
- linkedAllIssues(issueKey,[linkType])
- linkedIssuesByDepth(issueKey,depth,[linkType])
- hasLinks([linkType])
- linkedIssuesInProject(project,[linkType])
- linkedIssuesInVersion(versionId,[linkType])
- linkedIssuesInComponent(componentId,[linkType])
- linkedIssuesHasStatus (status,[linkType])
- inkedIssuesInVersionByName(versionName,[linkType])
- linkedIssuesInComponentByName(projectName, componentName, [linkType])
- linkedIssuesInQuery (jqlQuery,[linkType])
- linkedIssuesInFilter (filterId,[linkType])
- hasRemoteLinks([linkType])
- issueWhereEpicIn(jqlQuery)
- epicsWhereIssueIn(jqlQuery)
- epicsWithIssues
Worklog Functions
- workStartedOn(date,[User])
- workLoggedOn(date,[User])
- workUpdatedOn(date,[User])
- workLoggedBetween(startDate,endDate,[User])
- workLoggedAfterDate(date,[User])
- workLoggedBy(userOrGroup)
Group Functions
- groupsOfUser([user])
- groupMatches(regex)
Version Functions
- dueVersions([Project])
- overDueVersions([Project])
- openVersions([Project]
- currentVersionsBySeq([Project],[N])
- currentVersionsByDate([Project],[N])
- versionsAfterDate(date, true/false)
- releasedOn(date)
- versionsAfter(versionId)
- versionsBefore(versionId)
- versionMatches(regex)
- archivedVersions([Project]
Component Functions
- componentMatches(regex)
User Functions
- membersOfGroups(group1,group2,..,groupN)
- projectLeads()
- projectLead(project)
- usersInRole(project,role)
- userMatches(regex)
- inactiveUsers()
- usersInTimezone(timezone)
- componentLeads(ProjecyKeyOrComponentID)
Project Functions
- projectWithUserInRole(role,[user])
- recentProjects()
- projectMatches(regex)
Date Functions
- lastLoginOf(user)
- sprintStartDateOf(sprintName, [boardName])
- sprintEndDateOf(sprintName, [boardName])
- versionStartDateOf(versionName, [projectName])
- versionEndDateOf(versionName, [projectName])
Development Functions
- hasCommits()
- hasReviews()
- hasOpenReviews()
- hasPRs()
- hasOpenPRs()
- hasFailingBuilds()