Oracle script for Project information

Markeese Martin

I'm currently trying to retrieve project information from the database of Jira Data Center. The data I am after is.

 

• project name
• project key
• project lead
• if that lead's account is active or inactive
• last issue update date
• last issue create date
• total number of issues
• date project was created

There are MySQL and POSTGRESQL scripts out there however I need something compatible with Oracle.

Brant Schroeder

@Markeese Martin If you have a MySQL or PostgresSQL script you should be able to make some small tweaks to it and it will work on Oracle.  The table structure is the same in all DBs.