Automatically build task based on start and end date of Epic

[Lauren Robinette]

Hi there! I'm looking for some guidance on how to automatically create tasks based on the start and end date of my Epic.

Each Epic represents a project that we need to have 25%, 50%, and 75% check-ins on. I want a task built once we hit 25% into the campaign, 50% into the campaign and 75%. The logic would be (((Campaign End Date - Campaign Start Date) +1)*.25)+Campaign Start Date)) is the date we'd want the ticket built on. Repeat for 50% and 75%.

I do not want these tickets dependent on a workflow change, because no workflow status change will occur at these intervals.

Thoughts or suggestions of add-ons to purchase, if needed?

[Jean-Théo [Adaptavist]]

Hello @Lauren Robinette

I believe the easiest way to do this would be to use a Scriptrunner Escalation service.

https://scriptrunner.adaptavist.com/5.0.2/jira/escalation-service.html

This allows you to run a script at an interval of time (in your case, every morning would be good). 

How it works : You write a JQL of the issues for which the script is relevant. All the issues selected in the JQL will go though the script. At the start of the script, you can compare your formula with the current date. If it hits one of your check-ins, you can then proceed with the task creation in the same script.

I hope this helps,

JT