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.
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)
Thank you very much for your response, i will go through and get back to you if i have more questions.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great @Ismail Sanni !
Glad I could help and you figured it out. This is advanced stuff :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.