Database Custom Fields with Kepler Plugin. Show a list of issues of one JIRA project in a Custom Field

1.- Install the plugin: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.keplercf 2.- Create a Custom Field of the new Type “Database Custom Field” 3.- Go to your apache-tomcat/conf/context.xml and add the Datasource (first you need to install the Database JAR Driver if it’s different database Oracle, MySQL,… for example in apache-tomcat/lib/mysql-connector-java-5.1.17.jar 4.- Restart Tomcat 5.- Go as Admin to –> JIRA –> Add-ons…

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

How to create a new Listener with Groovy ScriptRunner

Create a new file named Example.groovy Copy the file in the JIRA server, path {JIRA_HOME}/scripts/{package}/Example.groovy NOTE: if the script contains “package example.Example” {package} must be “example” in this case Then define the Custom Listener in JIRA > Add-ons > ScriptRunner Listeners In Note: put general Information, for example “MyFirstListener Example” In Project Key: put all the…

Read More