Forums

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

Extracting issues with timespent > original estimate+1h, is it possible?

Aleksei Katrich December 16, 2019

Hello, community

 

I faced an issue that I don't know how to extract all issues which 'timespent' field is on 1h higher than their original estimate.

 

Foir instance, I use the next filter: 

project in (XYZ, ZYX) and ( (originalEstimate <= 4h and workratio >=125) OR (originalEstimate > 4h and originalEstimate <= 8h and workratio >=115) OR (originalEstimate > 8h and originalEstimate <= 14h and workratio >=120))

 

And i extract all issues with time overspent, but for issues with 1hour original estimate and with 1h30m timespent it does not work correctly. 

 

Does someone know how to add something like " originalEstimate <= 4h and timespent > originalestimete+1h" ?

1 answer

1 vote
Alexander Bondarev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 16, 2019

Hi , @Aleksei Katrich !

It looks that it is possible with ScriptRunner add-on.

Look through the documentation.

 Script_JQL_Functions.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events