Want to transition tickets from Archive to To Do if start date is 7 days from today?

[Abhay Kulkarni]

Here is what I have so far. Also tried - {{now.diff(issue.startdate).days}}<=7. Please advise. 

Thank you. 

[Bill Sheboy · Accepted solution]

Hi @Abhay Kulkarni 

Have you tried updating your JQL, to add the status condition, and remove the condition from the rule?  For example:

project = yourProjectName AND "Start date[Date]" <= startOfDay(7d) AND status = "Archive"

Then the rule will only run when there are issues to process.

Kind regards,
Bill

[Abhay Kulkarni]

Hello Bill, thank you for your response. That did not work either. Any other ideas? 

[Bill Sheboy]

When you note "that did not work either", what did you observe happening?

And please post your current, complete rule so we can compare your changes to what I suggested.

[Abhay Kulkarni]

Followed your earlier suggestions on the query and removed the condition in the rule : 

JQL Query - project = "Test" AND "Start date[Date]" <= startOfDay(7d) AND status = Archive

Ran the rule but the issue with a start date of 10/30 did not transition over to TO DO. There are no errors in the log. 

[Bill Sheboy]

Please post an image of the audit log details showing where you ran the rule.

And, if you run that JQL stand-alone, in View All Issues search, does it return anything?

[Abhay Kulkarni]

Yes, I get the tickets with a start date that is more than 7 days out. when I run the query by itself.

In the Audit logs, dont have a Failure or a Success Message, just the config change. I ran the rule within the Test Board -> Automations. 

[Bill Sheboy]

I do not see the rule run shown.

Did you select "Run rule" from the editor to force it to run now, rather than waiting for the schedule?

[Abhay Kulkarni]

Yes sir. I did. 

[Bill Sheboy]

Then why does it not appear in the audit log for this rule?

[Abhay Kulkarni]

I had the rule disabled! My bad. Thank you for your help, Bill :) 

[Bill Sheboy]

I wish Atlassian would disable that button when rules are disabled  :^)

[Abhay Kulkarni]

Indeed! Or at least a pop up letting the user know to enable the rule before testing it out.