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_ · Accepted solution]

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)

[Ismail Sanni]

Hi @Rebekka Heilmann _viadee_ 

Thank you very much for your response, i will go through and get back to you if i have more questions.

Thanks

[Ismail Sanni]

@Rebekka Heilmann _viadee_ 

Thanks, it worked 

[Rebekka Heilmann _viadee_]

Great @Ismail Sanni !

Glad I could help and you figured it out. This is advanced stuff :)