Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

connecting jira workflow transitions to an external database event

I need to trigger a certain even in an external database when a workflow status transitions from A to B. I have successfully used the post function which triggers a webhook on status transition but i am still stuck with triggering a database function. since webhooks accept 'https' in the url so no database address can be specified there. How to connect the workflow transition to the databse (which i connected using scriptrunner resources) . i am not on jira cloud

1 answer

0 votes

You can use SR to connect to a database and issue SQL in it.  The main recipe I have bookmarked for that is https://scriptrunner.adaptavist.com/5.4.28/jira/recipes/misc/connecting-to-databases.html

Thanks Nic, I had gone through the above adaptavist resource but my main concern still remains how to connect workflow transitions to the database? I can query the database using sqls but how will the database know when an issue is say updated?

You can put the code that connects to the database into post functions (if you want to issue the SQL on issue changing status), or listeners if it's for any form of update.

I am sorry but I think I didn't understand you. The database connection will be achieved by SR resources. What am I supposed to write in the post functions? Also I saw only predefined post functions, does jira allow custom postf too? Apologies for too many questions, I am new to JIRA .

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

New Cloud Apps Roundup - April 2021

Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...

253 views 3 20
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you