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 More

New 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 More

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