Update custom fields value

Question

Hello,

I have migrated JIRA from 6.2 to the 7.3 version. I was using Jelly Services to update the values in my custom fields every 60 minutes from another DB.

I'm looking for a solution to replace those jelly services with another service but I don't find anything.

My goal is to have a script that will run every 60min and will pick up informations from my DB with SQL and add changes in my custom field directly in JIRA, without creating a new custom field.

Thank you in advance for your help.

Francesco Amoroso · Answer

Thank you for your answer ! Yes I've tried databasecf add-on but I have to create new custom fields and I have to use absolutely the existing custom fields. I have Script runner add-on but I don't know how to translate the Jelly script code in groovy. For example I have that jelly code: (I'm totaly lost with the atlassian classes and methods)

Renjith Pillai · Answer

* Is this something you can use instead of doing an update every 60min? - https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf/server/overview

If you still need to do the update every 60min:

* If you are ready to pay for the script runner, you can use https://scriptrunner.adaptavist.com/4.3.0/jira/services.html
* Another option will be to write an add-on which does that.