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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,455,417
Community Members
 
Community Events
175
Community Groups

How to update/ write data to database which relate to JIRA project

I need to update colum value  from In complete to Complete when the JIRA ticket status change from In Progress to Done. How I can achive that.Can I use REST APIs to do that?

1 answer

0 votes
Trudy Claspill Community Leader Jan 23, 2023

Hello @Mangala Kalpani 

You cannot interact directly with the database when you are using a Jira Cloud subscription.

Are you saying that for issues that were in a status of "In Complete" you want that status to be renamed as "In Progress"? 

If I am understanding your problem correctly, that sort of change can be done without writing directly to the database.

Are you working with issues that are in a Company Managed project or a Team Managed project? That information will be shown at the bottom of the navigation pane on the left.

Essentially you just need to update the name of the Status. The Status's unique numeric ID is what is actually recorded in the issues and history. When you update the name of a Status, that change will automatically be reflected everywhere that Status value was used.

The process for making that update depends on the type of project you are using.

Note that if you are trying to update issues in a Company Managed project, then this sort of change can affect all Company Managed projects that used the same Status values.

Hi @Trudy Claspill , Thank you for the response.

If I further explain about my question, I want to make an integration between JIRA and SQL server to push some data like issues, issue's status from JIRA, to be saved in my database for analytical purpose. How to achieve that?

Trudy Claspill Community Leader Jan 24, 2023

What problem are you trying to solve by creating your own SQL database for storing some of the Jira data? Could you accomplish the same with third party apps that are designed to extend the reporting capabilities for Jira?

We have a customized dropdown field, named as “RoleStatus”. Let’s say that it has two values that can be chosen by the user (Active / Inactive).

When the user updated the RoleStatus from “Active” to “Inactive” it will update in the Jira itself.

We are currently doing an evaluation on Jira.

What I want is that the updates/changes which occurred on the Jira to be pulled out from Jira and send it to an external DB which is located in my PC.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events