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

[Raj Kumar]

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

[Robert Dzido]

Hi,

Please note that validator is executed against main inssue, not sub-task.

To obtain your goal you can use Workflow PowerBox app. It has option to run post function based on some condition (eg. when it's less than 7 days till end date).

It also has option to run validator using JQL.

[Raj Kumar]

Hi Robert,

Thanks for your response.

Is there a way I can do it without this app

Thanks,
Raj

[Robert Dzido]

Hi,

It can be possible with Automation or Script runner, but I don't have Automation for Jira installed to check it out.

[Raj Kumar]

Hi @Robert Dzido ,

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

Thanks,
Raj

[Robert Dzido]

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]

Hi @Robert Dzido ,

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