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.
If you still need to do the update every 60min:
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)
<sql:query var="valuesToAdd">
<!--My select SQL Query-->
</sql:query>
<!--options activées mais n'existant pas dans la table de référence-->
<sql:query var="idOptionsToDisable">
<!--My select SQL Query-->
</sql:query>
<!--options désactivées mais existantes dans la table de référence-->
<sql:query var="idOptionsToEnable">
<!--My select SQL Query-->
</sql:query>
<core:new className="com.atlassian.jira.component.ComponentAccessor" var="componentAccessor"/>
<core:invoke on="${componentAccessor}" method="getCustomFieldManager" var="customFieldManager"/>
<core:invoke on="${customFieldManager}" method="getCustomFieldObject" var="customField">
<core:arg type="java.lang.Long" value="10163"/>
</core:invoke>
<core:invoke on="${customField}" method="getConfigurationSchemes" var="fieldConfigScheme"/>
<core:invoke on="${fieldConfigScheme[0]}" method="getOneAndOnlyConfig" var="fieldConfig"/>
<core:invoke on="${componentAccessor}" method="getOptionsManager" var="optionsManager"/>
<core:forEach items="${valuesToAdd.rowsByIndex}" var="row">
<core:invoke on="${optionsManager}" method="createOption">
<core:arg type="com.atlassian.jira.issue.fields.config.FieldConfigImpl" value="${fieldConfig}"/> <!--Field config-->
<core:arg type="java.lang.Long" value="${null}"/> <!--parent option id -->
<core:arg type="java.lang.Long" value="${null}"/> <!--sequence-->
<core:arg type="java.lang.String" value="${row[0]}"/><!--value-->
</core:invoke>
</core:forEach>
<core:forEach items="${idOptionsToDisable.rowsByIndex}" var="row">
<core:invoke on="${optionsManager}" method="findByOptionId" var="optionToDisable">
<core:arg type="java.lang.Long" value="${row[0]}"/>
</core:invoke>
<core:invoke on="${optionsManager}" method="disableOption">
<core:arg type="com.atlassian.jira.issue.customfields.option.Option" value="${optionToDisable}"/>
</core:invoke>
</core:forEach>
<core:forEach items="${idOptionsToEnable.rowsByIndex}" var="row">
<core:invoke on="${optionsManager}" method="findByOptionId" var="optionToEnable">
<core:arg type="java.lang.Long" value="${row[0]}"/>
</core:invoke>
<core:invoke on="${optionsManager}" method="enableOption">
<core:arg type="com.atlassian.jira.issue.customfields.option.Option" value="${optionToEnable}"/>
</core:invoke>
</core:forEach>
<core:invoke on="${optionsManager}" method="getOptions" var="options">
<core:arg type="com.atlassian.jira.issue.fields.config.FieldConfigImpl" value="${fieldConfig}"/>
</core:invoke>
<core:invoke on="${options}" method="sortOptionsByValue">
<core:arg type="com.atlassian.jira.issue.customfields.option.Option" value="${null}"/>
</core:invoke>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.