nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Craig Nodwell_7eve9b

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

startOfWeek()

startOfWeek("inc")

_{where inc is an optional increment of (+/-)<strong>nn(y|M|w|d|h|m)</strong>.<span> </span>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.}