Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Can JIRA JQL perform calculations on data?

I would like to know if someone can tell me if JQL have the ability to build calculations with the JIRA data.

3 answers

2 votes
Jack Community Leader May 20, 2021

JQL is not designed to perform calculations. One option might be Automation depending on your actual requirements. 

Where is automation and what is it?  How can I access this?

Jack Community Leader May 24, 2021

It appears that you are on server. Which means automation for Jira is not built-in. So you will need an add-on for doing any kind of automation. You could consider automation for Jira , script runner or similar.

Where can I access this or download?  

I looked and we don't have that ability to download script runner into our JIRA.  Is there any other way to build calculations into filters then using them \for dashboards?

Ok I will rework this.  Here is a filter statement.  

project = "Global Treasury Services" AND type in (Story, Bug) AND fixVersion in ("CR220 - May 16, 2020 Release") ORDER BY issuetype DESC, key AS


All I want to do now is add that if the Labels field contains "UAT Testable"  Then return those only the work requests that meet the criteria before this statement and also if the text "UAT Testable" is contained within the Labels field.  Can someone please help? 

Suggest an answer

Log in or Sign up to answer

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