Update db driven field based on another field update

[Hans-Hermann Hunfeld]

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

[Silviu Burcea]

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

[Nic Brough -Adaptavist-]

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)