Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How can I use jira database?

Đạt Trần June 21, 2021

Hi! i am a programmer, my company wants to develop a system of sales statistics in jira. How can I use your database?

1 comment

Comment

Log in or Sign up to comment
Hyrum Steffensen _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 21, 2021

 

Hello Đạt,

Consider a plugin found in the Atlassian Marketplace.

To access the database in Jira, you can use the datasource connection in Power Scripts. You can then make queries using the sql() routine. Once you have the data, you can export the data to .csv using the printInFile() routine.

If you are using Jira Data Center, take a look at the all new Power Database Fields PRO. This will allow you to display data directly in Jira UI.

Screen Shot 2021-06-21 at 10.08.54 PM.png

Please answer the following questions so that we get a better idea of your requirements:

  • How would you like to process the data?
  • How would you like to display the statistics?
    • In a report?
    • In the view screen of an issue?

Regards,

Hyrum

Due to Confluence Cloud security features, you may need to open the documentation in incognito mode or by logging out of Confluence.

Please note that I am a product engineer for Power Scrips and I work for Anova Apps (Appfire).

TAGS
AUG Leaders

Atlassian Community Events