nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get historical values from custom field with scriptrunner

Eren Dogan_04myzm

Hello,

i am trying to get the historical values of a custom field in scriptrunner. My intend is to find out if and how jira saves these values over time to determine if i can use it in EasyBI to plot the value over time. I didnt had success figuring it out directly in EasyBI.

I have looked at the ChangeHistoryManager but it looks like it only supports Issues not custom fields.

Any ideas or tips?

Thanks

Accepted answers

Roberts Čāčus - eazyBI

Hi @Eren Dogan ,

Please look at an example from the eazyBI documentation page on how to import the field changes registered in a Scriptrunner field into eazyBI - https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/jira-calculated-and-scripted-custom-fields#Jiracalculatedandscriptedcustomfields-Originalestimatedhourshistory.

The particular example considers the system field "Original estimate". Still, the same concept should apply to custom fields.

Best,

Roberts // support@eazybi.com

All comments

Antoine Berry

Hi @Eren Dogan ,

Please see the following snippet that displays the values history of a custom field or a given jira issue :

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean


def issueManager = ComponentAccessor.getIssueManager()
def issue = issueManager.getIssueObject("JRA-XXX")

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def ch = changeHistoryManager.getChangeHistories(issue)

int count = 1
for(int i=0 ; i <= ch.size() - 1; i++){
for (ChangeItemBean bean:ch.get(i).getChangeItemBeans()){
if (bean.getField() == "Name of your custom field"){
log.info("value " + count + " : " + bean.getToString())
count++
}
}
}

Hope that helps.

Roberts Čāčus - eazyBI

Hi @Eren Dogan ,

The particular example considers the system field "Original estimate". Still, the same concept should apply to custom fields.

Best,

Roberts // support@eazybi.com

Eren Dogan_04myzm

Thanks Antoine,

this helped, i got the values i was looking for.

Eren Dogan_04myzm

Hi Robert,

thanks for your answer, thanks to Antoine i got to look at the values in JIRA/Scriptrunner console. Your suggetions unfortunately, isnt quite what a was looking for.

I added the "Import changes" option in sources with adding some advanced settings (https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history#Importissuechangehistory-Customfielddimensions), but my problem is that the desired field is of type select list single and therefore there aren't any measures findable in regards to change and/or history like with number fields.

Do i have to create a calculated measure to access the change values and if so what be the correct way?

Thanks in advance.

Roberts Čāčus - eazyBI

Hi @Eren Dogan ,

What type is the custom field in question? The parameters from the eazyBI documentation page you shared will work for the original custom field, if it is a single-value custom field.

Value change won't work with scripted custom fields. For that reasons, they have to be mapped to the Time dimension.

Best,

Roberts // support@eazybi.com

Eren Dogan_04myzm

Hi,

The field type is a Select List Single, its used in a project as a drop down menu where three options are available and only one can be selected. The field is not being change by scripts, just by users.

Thanks.

Inayat Nahvi

Hi @Antoine Berry . I tried this in the script console. It compiles but show no output. I inserted an issue key and a custom field name, but it returned no output.

Should this snippet return all change history of a specific custom field on that issue? Would it work for a multi-line text field? Thanks.