It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you