nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a rule that reminds when a task is near the start date?

Glaucia Jourdain

Hello Atlassian friends,

I am new to JMW, so JQL and smart values are not my expertise. My rule on "send reminders when task is near start date" failed. I believe I didn't get the JQL smart values correctly. I should also mention I used a due date rule as base for this rule. Please advise.

numberOfDaysBeforeStartInclusion

startdate <= endOfDay({{numberOfDaysBeforeStartInclusion}}) AND statusCategory != done AND assignee != empty

Startdate <= endOfDay({{numberOfDaysBeforeStartInclusion}}) AND statusCategory != done AND assignee = {{distinctAssignee}}

Accepted answers

Trudy P Claspill

Hello @Glaucia Jourdain

Welcome to the Atlassian community.

Please show us the details of the Create Variable step where you are defining numberOfDaysBeforeStartInclusion.

Please show us the Audit Log details for an execution of the rule where you did not get the results you expected.

Exactly what results do you expect, and what results actually occurred?

All comments

Trudy P Claspill

Hello @Glaucia Jourdain

Welcome to the Atlassian community.

Please show us the details of the Create Variable step where you are defining numberOfDaysBeforeStartInclusion.

Please show us the Audit Log details for an execution of the rule where you did not get the results you expected.

Exactly what results do you expect, and what results actually occurred?

Trudy P Claspill

Hello @Glaucia Jourdain

Are you still needing assistance with this Automation Rule?

If so, can you provide us with the additional information I requested?

Glaucia Jourdain

Hello @Trudy P Claspill I was on annual leave, sorry for the delay. I hope it is ok to pick this conversation up were we left. Ill send over the details requested. Thank you.

Glaucia Jourdain

As I mentioned before, I am new at this and my goal is to have a rule that sends a reminder emails when a task is near its starting date. I created this rule follows the steps of the well functioning "When a task is near due → send email reminder" rule. However the starting date rule fails every time. See bellow snip shots of details of the Create Variable step numberOfDaysBeforeStartInclusion defied as smart value 1, Audit Log details for an execution of the rule where you did not get the results I expected and results do you expect successively. I hope you can use these info. Looking forward hearing back from you. Thanks.

Error 1.PNG

Trudy P Claspill

Hello @Glaucia Jourdain

The rule for Due Date works because Due date is a special built-in field in Jira. It can be referenced in JQL using either "Due date" (the field name you see when viewing the issue details) or duedate. For most other fields you need to make sure that the name you use in JQL matches what you see when you view the issue.

This message

Screen Shot 2023-08-28 at 3.58.43 PM.png

indicates you have not chosen the correct field name for using your start date field as criteria for the JQL statement. Usually this will be the name of the field that you see when you are viewing the issue.

Example:

Screen Shot 2023-08-28 at 4.00.31 PM.png

If the field name has a space in it, like in this example, then you need to put it into quotes.

Example:

"Start date" <= endOfDay(.....

Try making that change and see if that helps.

Glaucia Jourdain

Hello @Trudy P Claspill

The rule still is not working properly yet, the JQL did not bring the issue up on the email notification. I have got a notification that an issue is due to start but no link to the issue itself. I had made changes only in the JQL look up to state "Start date" at the begging for the formula but had not changed anything on the variable value. Any thought?

I suspect the variable value is wrong, as this value appears in every JQL look up: the value is numberOfDaysBeforeStartInclusion, shouldn't it be or numberOfDaysBefore"Start date"Inclusion ?

Any thought? Thanks

variable 2.PNG

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-work-management

jira-work-management-cloud