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 click on the linked pages for full syntax of functions, description of the functions and sample queries.

---

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 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])
• 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)
  

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)
• 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()

Installation

Configuration

Usage

Licensing

FAQ