Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Math Query in Automation

Samantha Gardiner
Contributor
March 16, 2023 edited

I have created a query to sum my custom Dev and QA estimate fields to the Original Estimate field.

It was working fine, then I decided I wanted a more descriptive fields name.

After I changed the name of the custom fields, the automation no longer works. I updated the queries to use the new names but it is still not working. Is there somewhere else I need to update the names? The issues are all showing the new names.

Could you review my automation and see if you can find any issues? Did I inadvertently edit my JQL that I am not noticing?

Here is the JQL to sum the custom fields and populate them in the Original Estimate:

{{#=}}{{issue.Dev Estimate Hours.multiply(60).plus(issue.QA Estimate Hours.multiply(60))}}{{/}}

Screenshot 2023-03-16 at 11.37.23 AM.png

 

Screenshot 2023-03-16 at 11.33.27 AM.png

1 answer

1 accepted

4 votes
Answer accepted
Samantha Gardiner
Contributor
March 16, 2023

I've resolved this myself. By adding the word "Hours" to my name, it is confusing the JQL. Once I removed the word "Hours" it works again.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events