how to copy JMCF Calculated number value to another custom field (number field)?

[Aaron Grajera]

JMCF plugin installed.

i'm trying to generate a measure (JMCF Calculated Number Field) in EazyBI but cannot get the value of the custom field from JMCF.

[Nauris Malitis · Accepted solution]

Hi @Aaron Grajera 

Thanks for the question!

To import values from a JMCF custom field, you first need to add this field through the Advanced settings.

Please see this documentation page on Jira calculated and scripted custom fields

1) Add the following lines to the Advanced settings:

[jira.customfield_NNNNN]
data_type = "integer"
measure = true

2) For a numeric field, specify if this is going to be an integer or decimal data type.

3) Replace the NNNNN with the ID of the custom field. You can find the ID in the Jira admin panel -> "Issues" -> "Custom fields" -> "..." and hovering over one of the buttons like this:

4) Save the settings, head over to the Import options and you should see this custom field available for import:

Let me know if this works as expected! :)

Best regards,

Nauris

[Aaron Grajera]

Worked, Thanks for that @Nauris Malitis !

[David Fischer]

Hi @Aaron Grajera 

the problem lies in EasyBI, which doesn't seem to support calculated fields in Jira (JMCF or ScriptRunner). You should open a support request with them and see what they say.

As for copying the value of a calculated field into a non-calculated field, you can use any post-function to do that, such as JMWE's Copy Issue Fields post function, but the question is: when would you do that? JMWE post functions can run during a workflow transition, during an event, or on a schedule (using scheduled actions). But if you have a lot of issues, it can take a long while to update all issues.

The best solution to your problem is to have EasyBI support JMCF calculated fields.

[Aaron Grajera]

Hi david, yes i am aware that JMCF calculated fields are not supported by EazyBI, but is there a way to achieve copying the the JMCF calculated value to a non calculated field (custom field - number field), natively?

my JMCF calculated value happens when i transition an issue.

Yes, i agree with EazyBI supporting JMCF calculated fields. ill try to reach out to support.

Thanks!

[Suprija Sirikonda _Appfire_]

Hi @Aaron Grajera,

1. Can you share more details on the below? Where are you not getting the value of the JMCF field?
   but cannot get the value of the custom field from JMCF. 
2. Could you provide additional information regarding the below? How are you trying to achieve it? Screenshots showing the same will help us.
   i'm trying to generate a measure (JMCF Calculated Number Field) in EazyBI
3. Also, I see you mentioned the below in the Summary of this post: Do you want to do this as part of a workflow transition? Are you using any app to do it?
   how to copy JMCF Calculated number value to another custom field (number field)?

I'm Suprija from JMCF (Appfire) support team. We have opened a support ticket in our support portal, SUPPORT-99517 to better track your request. However, we couldn't add you as a reporter. Please sign up using this link and share the user name/id here. We'll then add you as the reporter and confirm. 

Thanks!

[Aaron Grajera]

Hi @Suprija Sirikonda _Appfire_ ,

• Can you share more details on the below? Where are you not getting the value of the JMCF field?
  but cannot get the value of the custom field from JMCF. 

JMCF is working as it is. I just want to copy this value to a custom field (number field) because JMCF values are not supported in EazyBI.

• Could you provide additional information regarding the below? How are you trying to achieve it? Screenshots showing the same will help us.
  i'm trying to generate a measure (JMCF Calculated Number Field) in EazyBI

JMCF values are not appearing in Custom Fields Import for EazyBI, i have a JMCF calculated field called Entity Progress (weighted).

• Also, I see you mentioned the below in the Summary of this post: Do you want to do this as part of a workflow transition? Are you using any app to do it?
  how to copy JMCF Calculated number value to another custom field (number field)?

I am still figuring out if i can natively copy the JMCF calculated fields to a custom field (number field) using workflow transitions. do you have an idea if this is possible?