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; } } }

calculate the date and time with two custom field

rTrack Support

Hi ,

our requirement is to find the difference between the two date time custom fields .is it possible ??

if possible please provide me the solution asap .

i have installed JIRA misc custom fields and i tried with the below expression .But that is not working for me .

Examole : Field 1 :created date bs (customfield_19700)

Field 2 : Closed Date bs (customfield_19716)

i need to find how the time taken to close the issue from the created date field .

these are JIRA custom field date time picker .

and also if it is possible with created and resolved date field

@Formula: issue.get("customfield_19716")==null ? null : (issue.get("customfield_19716").getTime() - issue.get("customfield_19700").getTime()) / 1000 / 3600 / 24 -->

date.png

filter.png

days.png

Accepted answers

David _old account_

I assume you created a Calculated Number field, correct?

There is a small error in your formula, you need to check both fields for null values:

@Formula: 
if (issue.get("customfield_19716")==null || issue.get("customfield_19700") == null)
  return null;
return (issue.get("customfield_19716").getTime() - issue.get("customfield_19700").getTime()) / 1000 / 3600 / 24; --&gt;

And of course you could also use the created or resolved fields, see https://innovalog.atlassian.net/wiki/display/KB/Using+issue.get%28%3Cfield_name%3E%29+in+scripts for details.

All comments

David _old account_

I assume you created a Calculated Number field, correct?

There is a small error in your formula, you need to check both fields for null values:

@Formula: 
if (issue.get("customfield_19716")==null || issue.get("customfield_19700") == null)
  return null;
return (issue.get("customfield_19716").getTime() - issue.get("customfield_19700").getTime()) / 1000 / 3600 / 24; --&gt;

And of course you could also use the created or resolved fields, see https://innovalog.atlassian.net/wiki/display/KB/Using+issue.get%28%3Cfield_name%3E%29+in+scripts for details.

rTrack Support

Hi david ,

i accept this .

But i have a small query ..

i checked with the field but it does not showing any values .

fyr

i attached the screen shots ..

Field Type :Calculated Date time field

search Template : date range picker

@Formula:
if (issue.get("customfield_19716")==null || issue.get("customfield_19700") == null)
return null;
return (issue.get("customfield_19716").getTime() - issue.get("customfield_19700").getTime()) / 1000 / 3600 / 24; -->

filter.pngdate.png

But the field does not appearing in the screen

i have mapped the field in the screen .

Please help me on this ..

David _old account_

As I already said, it needs to be a calculated NUMBER field. You are returning a number (the number of days between two dates), not a Date.

rTrack Support

Yah its working fine .

Is it possible to take if the hours is 0 then need to show the minutes .

shall i do it by using the below script .

Vikas Jain_aadywk

Hi David,

If I return a String in 1w 2d 3h format, which searcher can I use?

David Fischer

Hi Vikas,

if you're returning a String, it means you're creating a Calculated Text Field. In that case, you have a choice between a Free Text searcher (and thus the "~" operator) and an Exact Text Searcher (and the "=" operator). Obviously, you won't be able to search by duration, since it's not a Duration type field (see https://innovalog.atlassian.net/browse/JMCF-228 for that).

David

unknown

Hi,
I have similar requirement. and trying to implement above said solution but seems to be an issue for me. Below is the screenshot from my Jira, request you to please assist

when I'm hovering mouse over red cross it shows below error

ldogangul

Hi David & all community,

I have solved my problem. I am using calculted text field. I am not so sure how it's resolved but I guess I had some issues with indexing. I recommend re-index after create or change a custom filed.

My sample code is like below:

@Formula:
if (issue.get("customfield_11807")==null || issue.get("customfield_11806") == null)
return null;
return (issue.get("customfield_11807").getTime() - issue.get("customfield_11806").getTime()) / 1000 / 3600 / 24; -->

@Formula:
if (issue.get("customfield_11808")==null || issue.get("customfield_11807") == null)
return null;
return (issue.get("customfield_11808").getTime() - issue.get("customfield_11807").getTime()) / 1000 / 3600 / 24; -->

It works fine. And I cath the time stamps and time duration between status change.

Hope your will work as well.

Best Regards, Levent..

unknown

Hi Levent,

I'm not finding calculted text field in jira's custom field. Do I need to install addon for this or need to enable it ? please assist

Regards
Neeraj

ldogangul

Hi Neeraj, when you go to the "Add Custom Field" there is an advanced section. If you select advanced then you need to see "Calculated Text Field". I guess it is in Jira's standart setup.. If it is not there probably you will need to install an add-on. In my case I am using Jira standalone server edition 6.2 version.. Hope you will find this option.

unknown

Hi Levent,
thanks for response, I understand I need to install "Jira Misc Custom Fields " addon in order to get calculated text field. I'm also having Jira server on 7.5.2

Regards
Neeraj

Mario_f7po25

Hi David,

your solution for calculating minutes:

@Formula:
if (issue.get("customfield_19716")==null || issue.get("customfield_19700") == null)
  return null;
return (issue.get("customfield_19716").getTime() - issue.get("customfield_19700").getTime()) / 1000 / 60  ; --&gt;

works perfectly fine for me. But now I have another use case. How do I integrate e.g. the systemfield "Created" into that formula? All my attempts so far failed unfortunately.

Thank you very much.

Kind regards
Mario

ldogangul

Hi Mario;

Try this code into your customfields...

@Formula:
if (issue.get("customfield_13721") == null) return null;
return ((Double)(issue.get("customfield_13721").getTime() - issue.get("created").getTime())) / 1000 / 3600 / 24 -->

Mine works..

Mario_f7po25

Thx a lot for the ultra fast feedback.

I'm getting the best results with this code:

if (issue.get("customfield_11411")==null || issue.get("created") == null)
return null;
return (issue.get("customfield_11411").getTime() - issue.get("created").getTime()) / 1000 / 60;

Unfortunately the BigDecimal Output doesnt look too good. Is there some standard expression to be used in the calculted number field for "Format Expression" to get only rounded full numbers? Or ofc some other place where this can be set?

Thanks again!

ldogangul

I wonder that too. I get decimal numbers referenced by dots. It would be better if I could have get whole rounded number..

Best Regards,

shiva

@David Fischer

I Have created a scripted field , i need to copy the field value to any text field,

But when i copy what i get is

How do i get the value of " Time-to-resolve" value copied to the text field or any field .

David Fischer

Hi @shiva ,

you have created a Scripted (Groovy) Duration calculated field. The internal representation of duration fields is in seconds. The display on the issue view is calculated at display time. This explains why you're getting a number (of seconds) when copying from that field.

To copy the duration string value to another field, you'll need to use the Set Field Value post-function instead, and use this Groovy script as the value:

def cfType = ComponentAccessor.customFieldManager.getCustomFieldObject("customfield_10400").customFieldType
cfType.durationFormatter.format(issue.get("customfield_10400"), "pretty-duration")

where customfield_10400 is the custom field ID of the Time-to-resolve field, and "pretty-duration" can be replaced with "worklog-duration" if you want work duration instead of calendar duration. You can also replace the format method with formatShort to get a short version of the string (e.g. "14h 24m")

shiva

@David Fischer

Thanks for the suggestion,

I have the post function, the section in the field= "Time-to-resolve(())" is the text field im trying to copy the value of the scripted field (( Time-to -resolve) ( customfield_22306)

And after the transition the error i get when transitioning is

David Fischer

@shiva the error is not coming from that JMCF calculated field but from a ScriptRunner scripted field

shiva

@David Fischer

so i should change the output format in script runner ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-administration

addon-com.innovalog.jmcf.jira-misc-custom-fields