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; } } }

About JQL Query (Date Range and Status Resolved)

Barış Özer

Hello everybody,

I want to show tickets with status "Resolved" in Service Desk Project and assignee baris.ozer between 01 January 2022 - 31 December 2022.

Is the JQL Query I made below correct?

project = SD AND status = Resolved AND assignee in (62069a8aed02400069a3ad5f) AND created >= "2022/01/01" AND created <= "2022/12/31" AND resolution != unresolved ORDER BY created ASC

Accepted answers

Ste Wright

Hi @Barış Özer

Can I confirm the logic for your rule is:

Project = SD
Status = Resolved
Resolution is not empty
Assignee = User
Date = Created - created during last year

---

If this is correct, this should work:

project = SD AND status = Resolved AND resolution is not EMPTY AND assignee = 62069a8aed02400069a3ad5f AND createdDate >= startOfYear(-1) AND createdDate <= endOfYear(-1) ORDER BY created ASC

or with static dates:

project = SD AND status = Resolved AND resolution is not EMPTY AND assignee = 62069a8aed02400069a3ad5f AND createdDate >= 2022-01-01 AND createdDate <= 2022-12-31 ORDER BY created ASC

Ste

All comments

Ste Wright

Hi @Barış Özer

Can I confirm the logic for your rule is:

Project = SD
Status = Resolved
Resolution is not empty
Assignee = User
Date = Created - created during last year

---

If this is correct, this should work:

project = SD AND status = Resolved AND resolution is not EMPTY AND assignee = 62069a8aed02400069a3ad5f AND createdDate >= startOfYear(-1) AND createdDate <= endOfYear(-1) ORDER BY created ASC

or with static dates:

project = SD AND status = Resolved AND resolution is not EMPTY AND assignee = 62069a8aed02400069a3ad5f AND createdDate >= 2022-01-01 AND createdDate <= 2022-12-31 ORDER BY created ASC