nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Nic Brough -Adaptavist-

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

All comments

Jobin Kuruvilla [Adaptavist]

This might be a good starting point.

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

Nic Brough -Adaptavist-

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

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,

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira