Two tricks to improve the performance and security of your Jira Server 7.4

There are two tricks to improve the performance and the security of a large Jira Server 7.4 For the first “trick“, we can develop a little Jira plugin, or we can set a “Script Fragment” with the plugin Adaptavist Groovy Scriptrunner. The purpose of the improvement is to avoid problematic JQL queries. In Jira, by default,…

Read More

JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Very easy, see the JQL example: Project = “JIRA” AND Status CHANGED TO “In Progress” DURING (“2015/08/01″,”2015/10/05”) Other Syntax: This JQL shows all issues which have been in “Status A” for more than 14 days project=XXX and status changed to “Status A” before startofday(-14) and status = “Status A” This JQL shows all issues which…

Read More

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