JQL Question

Benoît March 25, 2018

Hello,

how can I compare 2 fields in a JQL query? I want to list the requests that timespent> timeestimate to list requests that exceed the time originally planned.

Thank you in advance for your help.

Best Regards

1 answer

2 votes
mschonarthatlassian
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 25, 2018

Hello, Benoit

If I understood your request correctly, you want to filter all the requests that have exceeded the original estimated time.

You can use the Work ratio keyword to achieve that. Work ratio is calculated as workRatio = (timeSpent / originalEstimate) x 100. Searching by type = Request and workratio>100 should do the trick!

I’d recommend checking out of Advanced searching under Keywords reference for further details on this topic. Feel free to ask if you have further questions.

Cheers!

Suggest an answer

Log in or Sign up to answer