Transition issue external database query

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

1 answer

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.