Can I use JQL with day of the week?

Dear all

I want to query the issue generated from Monday to Friday using the JQL.

Is there any way ?

2 answers

1 vote

Answer accepted

Hi JongBum Lee,

what about following jql:

created &gt;= startOfWeek() AND created &lt;= endOfWeek() ORDER BY created ASC

if you want to query last week you can edit it like that:

created &gt;= startOfWeek(-1) AND created &lt;= endOfWeek(-1) ORDER BY created ASC

Hope this helps?

Cheers,
Mario

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks Mr. Mario. I can not write English very well. Sorry. I want "Create Issue Monday to Friday (except saturday and sunday)" no matter what week

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

1 vote

I'm afraid you'll need to find/write a JQL function to do that, or do something sneaky with a scripted field

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.