JQL Query required to find the tickets created on every Monday in a specific time

[Thangavel VELUCHAMY]

I need the JQL Query to find the tickets created on every Monday in a specific time

I could create a filter to find how many tickets are created on every Monday by the below JQL Query.

project = IITT AND issuetype in (Incident, Request, Task) AND created >= startOfWeek("+1d") AND created <= startOfWeek("+2d")

But the filter we required on shift basis, means how many tickets are created in first shift 

Every Monday (6.00 AM to 3 PM) ticket details and count.

[Craig Nodwell · Accepted solution]

Hi @Thangavel VELUCHAMY you can use hours and minutes in your query 

startOfWeek()

startOfWeek("inc")

_{where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfWeek("+1") is the same as startOfWeek("+1w"). If the plus/minus (+/-) sign is omitted, plus is assumed.}

_{From this page}

[Thangavel VELUCHAMY]

Hello Craig,

Either i can pass only one value inside the () symbol.

Is it possible to add (day and time) inside the () symbol ? if yes please explain.

example :

e.g. created > startOfWeek("+1") and created < startOfWeek("+2") ---> Monday. --> this query gives the result " tickets created on Monday"

But we required  " how many tickets created during first shift on Monday" Between 6:00AM to 3:00 PM

[Craig Nodwell]

Just do some math :)
re:
created > startOfWeek("+30h") and created < startOfWeek("+38h")

[Thangavel VELUCHAMY]

Hello Craig,

Thank you so much for your help.

Yes, its also possible.

We required the filter not only for Monday " for entire week"

Regards;
Thangavel