I am trying to develop an atlassian connect jira plugin. How to connect with jira ondemand database?

I am trying to develop an Atlassian connect jira plugin with Atlassian cloud spring boot connect framework. How to connect to jira on-demand database? Can I connect or connect? How is data stored in jira? which database is used?

2 answers

This widget could not be displayed.
Steven Behnke Community Champion Nov 13, 2017

You cannot connect to the database of a Jira Cloud instance.

The only data you may store in Jira Cloud is on Issue Properties. All other data must be stored by you in your app, in your database. 

Then how can I fetch the data from JIRA cloud instance?

Please read Steven's answer again.

Steven Behnke Community Champion Nov 13, 2017

Via the REST API. 

Okay, only via the REST API. And if there is no existing predefined API, then I cannot fetch my data. Please correct me, if I am wrong.

You are correct.  Forget about the database, your only access to data in a Connect add-on (or other external systems) is the REST API.

This widget could not be displayed.
Steven Behnke Community Champion Nov 13, 2017

Correct as far as I can understand. How about you yell us what data you're trying to retrieve? 

I want to calculate something, let it be X.  For that, I need the number of review defects per month where review defect is an issue type.

Steven Behnke Community Champion Nov 13, 2017

Understood.

Simply using the Search API while searching for 'type = Defect AND created < startOfMonth(-1)' should return you a count of all defects created in this month. 

The API you have available to you is Jira Connect and JIRA REST. Outside of that I can't comment. 

Okay, thank you for your valuable information. Very helpful.

Steven Behnke Community Champion Nov 13, 2017

Happy to help

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

536 views 23 15
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you