JQL Question

[Benoît]

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

[mschonarthatlassian]

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!