JQL Tricks Plugin

JQL Tricks plugin is a plugin which has 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.

Following are the list of functions included. Please see the function details for the exact versions where it is available and for examples.

---

Issue Functions

• hasAttachments([Count],[Operator])
• hasSameValues(Field1, Field2, [Field3] .. [Field n])
• commentedByUser([User])
• commentedOnDate(date)
• commentedAfterDate(date)
  
• attachedByUser([User])
• componentsFromProject(Project)
• movedIssues([type],[From],[To])
• hasSameVersions()

Subtask Functions

• parent(JqlQuery)
• subtask(JqlQuery)
• hasSubtasks([subtaskType])

Issue Links 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])
• issueWhereEpicIn(jqlQuery)
• epicsWhereIssueIn(jqlQuery)
• hasRemoteLinks([linkType])

Worklog functions

• workStartedOn(date,[User])
• workLoggedOn(date,[User])
• workUpdatedOn(date,[User])
• workLoggedBetween(startDate,endDate,[User])
• workLoggedAfterDate(date,[User])

Versions 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)

Component Functions

• componentMatches(regex)

User Functions

• membersOfGroups(group1,group2,..,groupN)
• projectLeads()
• projectLead(project)
• usersInRole(project,role)
• userMatches(regex)
• inactiveUsers()
• usersInTimezone(timezone)

Group Functions

• groupsOfUser([user])
• groupMatches(regex)

Project Functions

• projectWithUserInRole(role,[user]) 
• recentProjects()
• projectMatches(regex)

Date Functions

• lastLoginOf(user)

Installation

Configuration

Usage

Licensing

FAQ