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

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
AUG Leaders

Atlassian Community Events