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

Transition time for status is getting calculated incorrectly

zarina siddique

HI Team,

I have added a status (Triage) in an existing workflow. The Time in source status/Status Change Time is getting calculated incorrectly.

Sample Defect was created on 19/Nov/14 5:33 PM and status were changed on 21-Nov-14

Below is the example of a defect and its transition time

Open->Triage (Status Change Time 0d -2m -19s , Last Execution Date = 21/Nov/14 12:57 PM )

Triaged Resolved With Code Fix (Status Change Time 1d 19h 25m , Last Execution Date = 21/Nov/14 12:59 PM)

Resolved With Code Fix Deployed (Status Change Time 0d -8s , Last Execution Date = 21/Nov/14 12:59 PM )

Deployed Closed (Status Change Time 0d 2m 33s , Last Execution Date = 21/Nov/14 12:59 PM )

This above incorrect data for status change time.

with SQL query

Step Start Time End time Day Hrs Min Sec

--------------------------------------------------------------------------------------------------------

Open 11/19/2014 5:33:55 PM 11/21/2014 12:57:26 PM 1 19 23 31

Triaged 11/21/2014 12:57:26 PM 11/21/2014 12:59:45 PM 0 0 2 19

Resolved With Code Fix 11/21/2014 12:59:45 PM 11/21/2014 12:59:51 PM 0 0 0 6

Deployed 11/21/2014 12:59:51 PM 11/21/2014 12:59:59 PM 0 0 0 8

Closed 11/21/2014 12:59:59 PM 11/21/2014 3:44:02 PM 0 2 44 3

so on JIRA it should actually give

Open->Triage (Status Change Time 1d 19H 23m 31s , Last Execution Date = 21/Nov/14 12:57 PM )

Triaged Resolved With Code Fix (Status Change Time 2m 19s , Last Execution Date = 21/Nov/14 12:59 PM)

Resolved With Code Fix Deployed (Status Change Time 6s , Last Execution Date = 21/Nov/14 12:59 PM )

Deployed Closed (Status Change Time 8s , Last Execution Date = 21/Nov/14 12:59 PM )

Request you to please guide whether am i missing out anything while adding a status in an existing workflow or why the JIRA is showing status time incorrect

Accepted answers

All comments

Nic Brough -Adaptavist-

I can't understand the numbers you are seeing here. Where are you getting these "incorrect" JIRA numbers from?

Could you simplify this and just look at one transition too - let's say just the "Open -> Triage" one.

zarina siddique

Hi Brough,

The JIRAs aren't incorrect ...the Transition time getting calculated and appearing on JIRA application are incorrect.

So to simplify as u suggested lets say the transition from Open-> Triage

Defect was created on 19/Nov/14 5:33:55 PM and hence was in status "Open" (as per workflow)
on 21/Nov/2014 12:59:45 PM the status was changed to "Triage"
So the defect was in open status for 1 day 19 hrs 23 min and 31 sec
but the JIRA Transition "Status in Time" on application shows (0d -2m -19s)

Open->Triage (Status Change Time 0d -2m -19s , Last Execution Date = 21/Nov/14 12:57 PM )

as u analyze further for other transitions the "Status Change Time" shows incorrect data for other statuses too.

if u verify the JIRA application result shown in the previous post vis-a-vis with SQL query you u will be able to understand that "Status Change Time" is showing wrong data

i hope i'm able to convey the problem with one status(as suggested)

if u still unable to understand...feel free to tag on my email id.

Regards,

Zarina S

Nic Brough -Adaptavist-

Sorry, I was not clear. I want to know where Jira is showing you the incorrect results. You say "but the JIRA Transition "Status in Time" on application shows" - but WHERE are you seeing that? Which screen, and how do you get to see it?

zarina siddique

Hi Brough,

i have attached the screenshot below,

you can see the status change time under transition tab of Activity frame of a defect

Incorrect Transition time.png

Welcome!

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

Quick Links

Find more posts tagged with

jira