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

<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“