Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to filter on "Time Spent" for a workflow transition condition?

Jared Moore
Contributor
February 15, 2019

Hello,

I am trying to incorporate a transition condition that allows the issue to move from one status to the next. In this case, I want the Time Spent field to be > 0 and <= 30 minutes. Through the process of trial and error, I've concluded that > 0 works just fine but it's the <= 30 minutes that breaks the logic.

Here is my logic currently on the transition:

transition_conditions.jpgAny idea what I'm doing wrong? Perhaps the value in minutes is stored differently than a whole number?

For the record, I created a filter that says...AND timespent = 30 and it returned the issue just fine:

filter.jpg

Any help you can provide is greatly appreciated. Thank you!

1 answer

1 accepted

0 votes
Answer accepted
Jared Moore
Contributor
February 19, 2019

Figured it out for future seekers of knowledge: Jira stores time spent in seconds. Thus in my requirement above to be <= 30 minutes, I had to set the value as 1,800 (30 * 60). That FINALLY worked.

Stefan Anghel
Contributor
May 4, 2021

I cannot, in any way or form, find "Sum of Time Spent" as a field on which to build a condition...

I've tried all available condition types ("Value field"...)
image.png

 

 

What condition type did you use, @Jared Moore  ?

Jared Moore
Contributor
May 4, 2021

@Stefan Anghel you should be looking for the "Time Spent" field as shown below. Make sure to select the one with the Epsilon prefix as shown in the image:

image.png

This field will automatically sum all time logged on your issue.

Like Stefan Anghel likes this
Stefan Anghel
Contributor
May 4, 2021

Thank you @Jared Moore .

I have already solved my issue by interacting with some other community members on this other question.

The trick is to search for the field, as the dropdown only lists a subset of fields that are available for condition building.

Jared Moore
Contributor
May 4, 2021

Ah, that makes sense now. Glad that the community was able to help you!

Like Stefan Anghel likes this

Suggest an answer

Log in or Sign up to answer