A sub Task to be created only 7 days before the end date.

Question

Hi,

We have a workflow transition where we have a post function to create a subtask but I want this subtask to be created only before 7days of the end date. How can we achieve this?

I tried a validator which blocks the transition until I reached 7days of the end date and then using project automation to perform the auto transition but had no luck.

Below is the JQL used as automation rule condition;

issuetype = "Leave of Absence" and status="Leave of Absence In Process" and "End date" >= -7d

Your earlier response is appreciated.

Thanks,
Raj

Raj Kumar_xvdvyl · Answer

Hi @Robert Dzido _Almarise_ ,

Please find the JQL used it is not giving me the intended result can you please check and help.

Attaching screenshot for your reference.

In screenshot  Start date =06/03/2019 and end date= 09/16/2019

Robert Dzido _Almarise_ · Answer

Hi @Raj Kumar ,

What do you mean by "due in days of the end date". If end date is a custom field and you want to create sub-task not more than 7 days before "end date", your condition should look like "end date" < 7d

Raj Kumar_xvdvyl · Answer

Hi @Robert Dzido _Almarise_ ,

Can you help me with the JQL to filter out the tickets which are due in days of the end date?

Thanks,
Raj