How to make massive changes in JIRA JQL filters

Imagine you want to change the name or the classification of the project "categories" in your JIRA projects... or names of customfields.... Then, a lot of JQL queries and filters will fail... ¿How we can change the JQL sentences in mode massive of all filters of JIRA? The only solution is making the change in … Continue reading How to make massive changes in JIRA JQL filters

Advertisements

TopRows JQL Function for JIRA 7.2 + Scriptrunner

New custom JQL function for JIRA 7.x to filter the TOP ROWS of a Query! Very useful! By default filters the TOP 10 rows. The JQL function is writed in Groovy and deployed with Adaptavist Scriptrunner. Syntax example: (to extract the top 20 rows of a project called JIRA) issuefunction in TopRows( "project = JIRA ORDER … Continue reading TopRows JQL Function for JIRA 7.2 + Scriptrunner

LastCommentContains JQL Function for JIRA 7.2 + Scriptrunner

Do you remember the old post LasCommentContains: New JQL custom function in groovy? With JIRA 7.2 and the new Adaptavist Scriptrunner, the JQL function must be rewrited to work properly. Because after the JIRA migration from JIRA 6.3 to JIRA 7.2 changes a lot of very common classes, etc. You can see the usual changes in … Continue reading LastCommentContains JQL Function for JIRA 7.2 + Scriptrunner

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 … Continue reading JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Tutorial – Adding a JQL function to JIRA 6 – 7

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 … Continue reading Tutorial – Adding a JQL function to JIRA 6 – 7

JQL 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")

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