What to put in JQL field for a scheduled automation

Question

Hello,

I am new to Jira Work Management.  I'm trying to create an automation that will set priority of tasks based on due date.  I have set the automation to run once per day, but it appears that to enable such scheduled automation, I need to check the "Run a JQL search and execute actions for each issue in the query" box.  Once I do that, it pops up a required "JQL" field, but I am not sure what I am supposed to put into this field.  I tried inserting an account ID from the drop-down, but then when I test ran the automation, it gave me an error, so maybe something else was supposed to go into this box?

Thanks for any help you can provide!

Alex

Mark Segall · Answer

A minor tweak is that you could add this to your trigger query and remove from your conditions.  It'll perform a little better, but otherwise, your rule looks good.

AND status != Done

Alex Wood_hnwg96 · Answer

The idea is to set priority to "highest" <1wk out, and "high" <2wk out.  I've created a label ("manual") to allow people to exempt projects from this automation.

Mark Segall · Answer

Thanks for the additional context.  If you want to share a screenshot of your rule, we can help optimize it.  The query should only be required once at the trigger.  I would have something like this:

* TRIGGER: duedate <= 2w AND resolved is not empty
* IF CONDITION: Priority = High* ACTION: Do something

* ELSE: Priority = Medium* ACTION: Do something else