JQL Statement for Monday and Friday

Ismail Sanni March 4, 2024

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.

1 answer

1 accepted

2 votes
Answer accepted
Rebekka Heilmann _viadee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 4, 2024

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 March 4, 2024

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 March 4, 2024

@Rebekka Heilmann _viadee_ 

Thanks, it worked 

Rebekka Heilmann _viadee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

Great @Ismail Sanni !

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events