Automation for editing the Priority based on comparison with DateTime field.

[Viorel Ioan Pacurar]

I am trying to find a solution to help set priorities automatically, by comparing the current date/time with a set date/time field value.

1. Trigger - every hour.

2. Condition: Current Date/Time MINUS Start date/time custom Date/Time field < 1 hour. 

This condition should apply to all existing sub-tasks that contain a certain text in Summary (e.g. Setup).

The custom Date/Time field is located in the sub-tasks' details. 

3. Action: change the priority from any to Highest.

I tried to set this up, but I keep getting the same error for the trigger:

" 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"

This rule was not set using a JQL search query. 

Thanks in advance for your help.

[Bill Sheboy · Accepted solution]

Hi @Viorel Ioan Pacurar 

That error is indicating you are using conditions and actions which need issues, but the trigger doesn't provide any.

The two ways to address this are:

• Add JQL to your scheduled trigger to limit the impacted issues.  This has the benefit of reducing the number of rule executions as it will only fire when relevant issues are found with the JQL.
• Use the scheduled trigger without JQL (as you have done) and then use branching or lookup issues to get at the issues you want to evaluate.

Kind regards,
Bill

[Viorel Ioan Pacurar]

Hello Bill,

Thank you for your suggestions. 

I'll give it a try and post here a solution - if I find one that works.

Cheers,

Viorel.

[Viorel Ioan Pacurar]

Great success, it's actually in the basic functionalities of the automation tool. I overcomplicated the whole process in my head, that's why I got stuck earlier. 

Thank you Bill again for 'resetting' my approach. 

Cheers,

Viorel.