Automation to move a ticket from a hidden column to TO DO if start date is 7 days out

[Abhay Kulkarni]

Hello team! 

I'm looking to create an automation where I move tickets from a hidden column to TO DO if the start date is 7 days out. Unfortunately, it's not working. Looking for some help. 

[Bill Sheboy]

Hi @Abhay Kulkarni -- Welcome to the Atlassian Community!

For a question like this, please consider posting images of your complete rule, the details of actions / conditions / branches, and of the audit log details showing the rule execution.  Those will provide context for the community to offer suggestions.  Thanks!

Without seeing those things...

Please describe what is not working as you expect.  For example,

• Is the issue not transitioning?  Or...
• Is a different issue transitioning?  Or...
• Is the issue transitioning at the wrong timeframe?  Or...
• Something else?

Kind regards,
Bill

[Abhay Kulkarni]

Hello Bill! 

I've tried a few different variations of this now but to no avail. The automation runs successfully without transitioning the issue. 

Unable to upload images at the moment but here's my latest attempt - 

Scheduled: Every 5 mins 

JQL - {{now.diff(issue.startdate).days}}<=7 or 'Startdate' = {{now.plusBusinessDays(7).jiraDate}} AND Status="Archive" 

Then Transition issue to "TO DO"

Thank you! 

[Bill Sheboy]

The JQL statement you are using is invalid.  

You appear to want issues that will start in the next 7 days or farther out ones which are in an "Archive" status.  I do not think the part you include about business days is possible with the built-in JQL, although you could add additional tests in the rule.  Essentially you want something like this:

project = yourProjectName
  AND "Start date" >= startOfDay()
  AND "Start date" <= startOfDay("+7")
  AND statusCategory != Done

You could build in that for your other case, such as by expanding the time range and adding a diff() for business days and using a condition in the rule.

As a tip: it can help to create/test JQL using an issue search first, and then try it in rules.  Please look here for more information: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/