How do you apply a retroactive calculation + new custom field to existing tickets?

Mary_p0g6q3

Hello There -

Halp! Padawan Jira admin here.

I created a new custom field that calculates the TAT in weeks for a project that uses automation (which worked for the new, succeeding tickets. Whew!)

That same calculation needs to be applied to tickets from a specific period so I created another automation using the same logic with a slight modification: the addition of a range filter (Expected action: All tickets created after 12/31/2022 should show the TAT + new custom field). See below:

The rule ran BUT no fields or calculation was created. **faceplam**

What could be a better approach here? Are new fields not applied retroactively even if it is applied to the existing screen?

Thank you in advance for sharing your expertise.

Karim ABO HASHISH

hi @Mary 

I would suggest the below approach.

1. Create a Rule with Manual trigger
   
   
   
2. Add a new branch of type Branch Rule / related issues
   
   
3. put your JQL to get all historical tickets needed (it will be like looping over the tickets retrieved from the JQL to perform some actions on each one of them).
   
   
4. all the remaining steps is the same like the first rule you have configured for the new tickets.
5. Please pay attention to add your component/actions inside the branch not outside the branch to make sure that it will apply for all (check below)
   
   
6. Finally after competing all remaining steps, save and run manually.

 

Good Luck and let me know how it went for your or if any further help is needed.

Cheers,

Karim