Update db driven field based on another field update

Hi all,

currently we have the problem that we have to add some external data from HR to JIRA as we would like to add a kind of escalation process. Based on the assignee we plan to query the user´s supervisor, that´s currently working based on Kepler Database Field plugin.

But, while changing the assignee the value in the customfield "Supervisor" is not changing until we open the edit issue screen. It would be sufficient if the change is triggered by an transaction, but afaik this is not woking right now.

Any ideas how to solve this requirement? The field "Supervisor" is only one single value and don´t need to be updated manually, can stay readonly. Only the usage to copy this field to the assignee field while a transaction is done must be possible...

 

Many thanks in advance!
Hans-Hermann

2 answers

Hi,

 

Do not touch JIRA's database directly. Here are at least 2 safe JJupin solutions:

 

1. A SIL postfunction to update additional fields, like Supervisor

2. A SIL Listener script that's executed after every Issue Updated event

 

I wouldn't be surprised if there are more, but this should be enough for your use case.

 

Regards,

Silviu

0 votes

Do not update a JIRA database with SQL while it is running.  And even when it is offline, you probably shouldn't.

That's all I have to say about the SQL.  Stop doing it.

You need to go via the API to update JIRA data (whether you use REST, the UI or a plugin)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Feedback & Announcements

How do you analyze GC logs, thread dumps and head dumps?

Hi awesome community!  In this article, I would like to describe the one of the toolset (service) for the analyze some problems on different Java-based instances, of course, as Atlassian admini...

96 views 0 7
Read article

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