JQL Statement for Monday and Friday

Ismail Sanni

Hi Gurus,

Can someone help me with a jql statement for Monday and Friday.

So i want an email sent if when a ticket is created and the due date falls on a Monday or Friday. The only issue i'm having is the JQL condition. 

If this is not possible, can someone tell me if its possible to block out dates in Jira. Like when Monday and Friday is selected, the ticket doesn't get created and an error is shown to the reporter, by the way, I using JSM

Thanks.

Rebekka Heilmann (viadee)

Hi @Ismail Sanni 

Restricting Issue creation based on field content isn't possible with standard Jira but may be possible with Apps like Scriptrunner.

For the JQL - have a look at this thread:  Solved: How to query for specific days of the week in a gi... (atlassian.com)  The following JQL apparently works for wednesdays. You'd need to adjust the filter for Mondays/Fridays:

duedate = startOfWeek(-25d) OR duedate = startOfWeek(-18d) OR duedate = startOfWeek(-11d) OR duedate = startOfWeek(-4d) OR duedate = startOfWeek(3d) OR duedate = startOfWeek(10d) OR duedate = startOfWeek(17d) OR duedate = startOfWeek(24d)