How to convert Original estimate field into number?

[Suchithra s]

I want to copy original estimate field into any of the custom field

[Nic Brough -Adaptavist-]

There is an underlying thing that I think is worth explaining here.

The original estimate is not really a duration between two times or a list of elapsed weeks, days, hours, minutes and seconds.

Behind the scenes, it is a very simple number of seconds.  Everywhere you see it displayed like "2d 4h 15m" that is some code converting the number of seconds into a "pretty" display string.

So, when you "convert" an estimate to a number field, all you're really doing is copying a number of seconds.  The number field does not know that it is a number of seconds, and does not have any code to display it in the "pretty" format.

If you want it in a format other than a simple number of seconds, you'll have to copy it into a string field and do some coding to make it go through a "pretty" transformation.

[Suchithra s]

Hi Alex,

I tried this post function, but after the transition the text field took the value "None"

Regards,

Suchithra S

[Alex Koxaras -Relational-]

In the create transition, copying the value will not work. Also you have to make sure that there is a value within the original estimate field.

[Alex Koxaras -Relational-]

Hi @Suchithra s 

You can do that by creating either a Jira automation, or via a workflow post function. E.g. in Jira automation you could create something like the following:

[Suchithra s]

Hi Alex,

How can I do it from workflow post functions?

(Copy original estimate field value to any of the text custom field)

Regards,

Suchithra S

[Alex Koxaras -Relational-]

@Suchithra s  Add a post function like the following one:

[Suchithra s]

@Alex Koxaras -Relational- , That post function didn't work

I tried to copy the value to number custom field(Original estimate number), It throws the following error-> Please find attachment

I tried to copy the value to text custom field(QA ETA), It throws the following error-> Please find attachment

[Alex Koxaras -Relational-]

Then use the paragraph custom field. At least this works for me.

[Alex Koxaras -Relational-]

Or, if you had an app like JMWE, you could just copy the value:

[Suchithra s]

@Alex Koxaras -Relational- Yes, But it is showing in seconds format. How to Convert?

[Alex Koxaras -Relational-]

To convert it in which format?

[Suchithra s]

Minutes / Hours

[Alex Koxaras -Relational-]

You can't convert it. Or at least I can't.

The only way I know of how to really copy the value of Original Estimate (pretty) without converting it, is to use Jira automation with REST API and to copy the {{webResponse.body.fields.timetracking.originalEstimate}} smart value to your text field.

You could achieve that within the workflow with an app that supports API, like JMWE.