Is it possible to use calculations in JQL?

[Lena Boiser]

For example, I want to filter for tickets where the Time Spent has exceeded 50% of their original estimate (time). Is it possible to do that in JQL? 

[Sanjog Sigdel]

Hello @Lena Boiser 

Welcome to the community!

So far to my knowledge the percentage comparision, counting the issues, summing the values etc. via JQL. I've so far seen the less than <, greater than > comparision for the days and dates in the JQL.

Using Jira Smart Values we can perform sum and other operations.

I'm sure other community members will add to it.

[Kateryna_v_SaaSJet_]

Hi @Lena Boiser 

Check out this article — "16 Most Popular JQL Filters for SLAs in Jira Cloud". You can find some valuable examples there.

[Marc - Devoteam]

Hi @Lena Boiser 

You can have calculations in JQL.

You can use automation to do calculations, the outcome can be stored in custom fields (text, number). These fields can then be searched via JQL.

Or you can use the outcome of calculations in emails that the automation can sent.

JQL is a query langue only, it searches for stored information.