How do I create a project automation to run based on termination date?

Margaret Winward

I am using the HR Service Desk. An exiting employee has a resignation date and a termination date. I have a couple of questions:

• Where can I find the JQL fields so I know which ones to use?
• How do I set up the automation to run when the termination date is today?

It will look something like this although this one does not work. 

Petter Gonçalves

Hello @Margaret Winward

Thank you for reaching out. 

Per your description and rule, I understand that your final goal would be to create an automation rule that creates two new tasks for each existing task that has reached its due date. Is that correct?

Based on that assumption, I'll try to properly answer your questions and give you the correct instructions to achieve your goal:

Where can I find the JQL fields so I know which ones to use?

You can refer to the documentation below to properly understand how to  build your JQL query, know what operators (=, !=, is, etc), fields ("Due date", "Summary", etc) and functions (linkedIssues(), CurrentUser(), etc) you must use:

What is advanced searching in Jira Cloud? 

How do I set up the automation to run when the termination date is today?

The logic of the automation rule you created seems to be correct, however, there are some minor JQL errors. Please, create the rule following the template below:

If you are trying to achieve something different, please give us more details of your final goal so we can properly help you.

Let us know if you have any questions.