Transition issue external database query

Question

Hi,

How to do something like that:

Transition issue (job every day) when external database query (postgresql) return some value.

I need to change status to "Payed" when select query return 1 or True where IDissue_from_jira  = issueID

It's is possible by some plugins?

Regards

Mohamed Benziane · Answer

You will need to create a custom script that will read the external database and update some Jira issue.

https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html

Kondi · Answer

I try to find in documentation how to connect to external postgresql database, but i don't see that function at all

Mohamed Benziane · Answer

Hi @Kondi

You can try Scriptrunner, you should be able to create a job that query an external database and make some changes in Jira.