Scheduled automation error

[carlos sarrate]

Hi, I have an automation that runs on newly created tickets in a certain group that fills in a date 30 business days out in a new custom field. Using:  {{issue.created.plusBusinessDays(30)}}

Now I'm trying to fill in this field to all my existing tickets. So I duplicated the automation but I set the trigger to scheduled. This one unfortunately gives me this error.

 Error: The rule has been configured with components that require issues to be provided by the trigger. You need to use the option to run JQL to provide issues. The following components require issues: Issue condition, Edit issue

Can anyone see what I'm doing wrong?

[Marc - Devoteam · Accepted solution]

Hi @carlos sarrate 

In the automation scheduled trigger the option: Run a JQL search and execute actions for each issue in the query. needs to be checked and a search provided

[Trudy Claspill]

Or...

After the Scheduled Trigger you need a step such as Lookup Issues that will get a list of issues against which the remaining actions can be executed (with a For Each branch).

[carlos sarrate]

@Trudy Claspill and @Marc - Devoteam Looks like both methods require a JQL search is there a smart value that will give me all the open tickets?

[Trudy Claspill]

You need to construct a JQL filter to retrieve you existing tickets. If the field is new and empty in the issues where you want to fill it then I would recommend a filter that includes this

<Your custom field> IS EMPTY

You probably will want to include other criteria, such as specifying the project(s) that contain the issues.

There are limits on both the number of issues that can be received in a Scheduled trigger JQL and in a Lookup Issues action, so factor that into you JQL.

https://support.atlassian.com/cloud-automation/docs/automation-service-limits/