Reports development in JIRA

[Elmer Victor]

Hi!

We're into JIRA 5.2.x download using Oracle DB 11g and planning to create reports.

Where do we start? Is there a tutorial or documents designed for beginners? Is there a way to build report using Crytal , Oracle, or Jasper report but still use the security defined in JIRA?

Any help is highly appreciated.

Regards,

Elmer

[Nic Brough -Adaptavist- · Accepted solution]

To answer the implied bit about using the database directly (i.e. Crystal/Oracle), then no, most people don't bother to do this because

• You need to define and maintain a data dictionary, which sounds fine, until you understand that Jira's database is not simple, and can easily change on upgrades
• It does completely ignore ALL the permissions/security in Jira, rendering it either immensely complex to implement because you have to duplicate the logic

[Elmer Victor]

Thanks Nic. I guess our only chance is to create or use an existing plugin, right?

Regards,

[Nic Brough -Adaptavist-]

Finding or writing a plugin to do a report is often the best option. If you're going to be doing a lot of adhoc reporting, it may be worth investing in one of the generalised reporting plugins, which do respect the security.

It might also be worth telling us what the most important reports on your list are currently - people here have used a wide range of plugins, and we often find that someone can point us at a good guide or plugin that gets us close to what we need

[Elmer Victor]

Hi Nic,

As of this writing, another group in our company still collating the needed reports and we just want to make ready / prepare on the development tool that we're going to use. Will search the marketplace and/or bump here at answers.at.com soon.

For now, we're in the process of reviewing/following tutorials on the creation of plugin and must admit, a long way to go to develop one.

Kind regards,

[Jobin Kuruvilla [Adaptavist]]

This might be a good starting point.

https://developer.atlassian.com/display/JIRADEV/Plugin+Tutorial+-+Creating+a+JIRA+Report

[Elmer Victor]

Hi Jobin,

Interesting, however, that tutorial is kind of advance. Anyway, we're now checking the SDK documentation / plugin documentation and must admit a long way to go..

Thanks