Step 1. Create the plugin project If you have not already set up the Atlassian Plugin SDK, do that now: Set up the Atlassian Plugin SDK and Build a Project. Enter the following command to create a plugin skeleton: atlas-create-jira-plugin Choose 1 for JIRA 5 when asked which version of JIRA you want to create…
Read MoreLasCommentContains: New JQL custom function in groovy
Syntax: issueFunction in LastCommentContains(” query…”, “text to find”) Isn’t Key Sensitive
Read MoreJQL Custom Function UserInRole (with Groovy for JIRA)
JQL Syntax sample: project = XXX AND issueFunction in UserInRole(” “, assignee, “Developer”) // note the space in the first parameter, this syntax is less efficient issueFunction in UserInRole(” project = XXX “, assignee, “Developer”) //more efficient issueFunction in UserInRole(” project = XXX “, reporter, “Developer”)
Read MoreNew example of JQL Custom function
Here is a function with two input parameters to show, as result, a list of issues that it’s worklogged hours sum more than the input parameter two. It’s an easy function to know how create new JQL custom methods.
Read MoreCustom JQL Function “HasInactiveReporter” and “HasInactiveAssignee” compatible with JIRA 7

Script JQL Functions: Included Functions in Groovy ScriptRunner
JQL functions: hasComments commented lastComment lastUpdated hasAttachments fileAttached workLogged dateCompare hasSubtasks subtasksOf parentsOf hasLinks hasLinkType linkedIssuesOf linkedIssuesOfRecursive linkedIssuesOfRecursiveLimited expression aggregateExpression issueFieldMatch issueFieldExactMatch myProjects recentProjects projectMatch / componentMatch / ver earliestUnreleasedVersionByRelease addedAfterSprintStart removedAfterSprintStart incompleteInSprint completeInSprint nextSprint previousSprint inSprint(board name, sprint name) See more in Adaptavist ScriptRunner
Read MoreNew JQL Function Custom to retrive issues with inactive user in assignee “HasInactiveAssignee” or in reporter “HasInactiveReporter” (Jira 6 and 7)
On {JIRA_GOME}/scripts/ create this folders: For example: ../jira_home/scripts/com/onresolve/jira/groovy/jql Then add the groovy file with the new JQLFunction, exmaple: HasInactiveAssignee.groovy The code: Then Go to Addons –> ScriptRunner –> Script JQL Functions –> and then press “Scan” Syntax: issueFunction in hasInactiveAssignee(‘project = XXX’) That’s all!
Read MoreHow to add new custom JQL Function with ScriptRunner
On {JIRA_GOME}/scripts/ create this folders: For example: ../jira_home/scripts/com/onresolve/jira/groovy/jql Then add the groovy file with the new JQLFunction, exmaple: ABC.groovy Then Go to Addons –> ScriptRunner –> Script JQL Functions –> and then press “Scan” That’s all!
Read MoreJIRA Service with Groovy ScriptRunner “Closing issues with status X with N days without updates” usign JQL

JQL Reference manual (How to Perform an Advanced Search)
If you need more info about how to use JQL, tricks, etc, we strongly recommend the Book “JQL Per tutti” of Fabio Genovese (Artigiano del Software) Book available in Italian, Spanish, Catalan, French and English! JQL Manual: https://confluence.excentia.es/pages/viewpage.action?pageId=27329688 JQL Atlassian Manual: https://confluence.atlassian.com/display/JIRA/Advanced+Searching How to Perform an Advanced Search Choose Issues > Search for Issues. The issue navigator will be displayed. If there are…
Read More