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

Advertisements

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

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

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!

How 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!