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



<Resource name="jdbc/jiradb" auth="Container" type="javax.sql.DataSource" username="user" password="pass" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://host:port/jiradb?autoReconnect=true" validationQuery="select 1" />


4.- Restart Tomcat

5.- Go as Admin to –> JIRA –> Add-ons –> Kepler Plugins Config –> Database Custom Fields

6.- Set Database(JNDI name): jdbc/jiradb

7.- Set the SELECT: 


SELECT concat(project.pkey, '-', jiraissue.issuenum, ' ', jiraissue.summary) as PKEY,project.pname AS project,jiraissue.summary,issuetype.pname AS issuetype,
issuestatus.pname AS status,jiraissue.assignee,jiraissue.reporter,jiraissue.created,

FROM jiraissue,project,issuetype,issuestatus

WHERE jiraissue.project=project.ID AND jiraissue.issuetype=issuetype.ID
AND jiraissue.issuestatus=issuestatus.ID
AND project.pkey = 'XXX' AND issuestatus.pname='XXX'
ORDER BY created desc

And in Column set “PKEY

Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s