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

calculating child issues time

rTrack Support

Hi @Fidel Castro Armario ,

I need to calcualte the total time taken on each child issues and need to display it in the parent issue .

For ex :

Parent issue 1

child issue 1

child issue 2

child issue 3

These child issues are created using creates issues and subtask post functions .

in parent issues : open --> in progress --> resolved .

need to take the difference b/w resolved and created .

in the same parent issues :

open --> inprogress --> resolved --> rejected --> in progress --> resolved .

in this scenario , i dont need to take the difference between created and resolved .

i copied the transition time when it is resolved to rejected as Reopened Time .

Once again i changed to resolved Then resolved field will updated with the current time .

So i have to check the scenarios :

if Reopened date is null then need to take differenece b/w created and resolved .

else reopened date is not null then need to take the difference b/w reopened date and resolved .

image2017-2-21 10:30:44.png

Accepted answers

Fidel Castro

If you also want a field in each child issue, you can create a "Calculated Text Field" with the following text expression:

formatDuration({rrrrr} != null ? {ccccc} - {rrrrr} : {ccccc} - {00009})

replacing rrrrr with field code for Final Reopen Date, and ccccc with field code for Final Closure Date.

Note that {00009} is field code for Date and time of creation.

All comments

rTrack Support

so once calculated this time i have to display those times in the parent issues and also need to sum up the all field of calculated times and display in some other fields .

Fidel Castro

Do you have a Date-Time Picker custom field for storing the time when an issue is reopened? In affirmative case, what's the name of that field?

rTrack Support

Final Reopen Date – This date field will capture the reopen activity date time (Status : Reopened)

Final Closure Date - this date field will capture the close activity date time (Status : Resolved)

Fidel Castro

You can create a "Calculated Text Field" in parent issue with the following text expression:

formatDuration(sum(mathOnIssueList(linkedIssues("initiates (Issue originated from another Issue)"), ^{rrrrr} != null ? ^{ccccc} - ^{rrrrr} : ^{ccccc} - ^{00009})))

replacing rrrrr with field code for Final Reopen Date, and ccccc with field code for Final Closure Date.

Note that {00009} is field code for Date and time of creation.

Fidel Castro

If you also want a field in each child issue, you can create a "Calculated Text Field" with the following text expression:

formatDuration({rrrrr} != null ? {ccccc} - {rrrrr} : {ccccc} - {00009})

replacing rrrrr with field code for Final Reopen Date, and ccccc with field code for Final Closure Date.

Note that {00009} is field code for Date and time of creation.

rTrack Support

The duration will be in the format of time

like 2days 4 hrs 30 minutes .

And also .If i set the due date is with certain conditions once resolved the issues , i have to take the difference between resolved and due date .

if resolved date is greater than due date then need to set a field as SLA OUT .

else resolved date is lesser than due date then need to set a field with value as SLA IN

Fidel Castro

The format is like 2days 4 hrs 30 minutes.

Fidel Castro

I recommend you to create a Text Field (single line) custom field and set it in transition for resolving issue using "Copy a parsed text to a field" post-function with the following configuration:

Target field: the Text Field (single line) you have created.
Parsing mode: advanced
Text to be parsed:

formatDuration({00012} - {ccccc}) + " - " + ({00012} - {ccccc} &gt; 0 ? "SLA IN" : "SLA OUT")

replacing ccccc with field code for Final Closure Date.

Note that {00012} is field code for Due date.

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

com.fca.jira.plugins.workflowtoolbox.workflow-toolbox

addon-com.fca.jira.plugins.workflowtoolbox.workflow-toolbox