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


<Context>

....

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

</Context>

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: 

Exmaple:


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,
jiraissue.resolutiondate,jiraissue.duedate,jiraissue.description

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s