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

I need to get all closed tickets

Alex_2nfdtf

Hello, please advise. I really need your help
I need to get all closed tickets (from April 1 - July 1), but so that those that were created in the 1st quarter (from January 1 - to April 1) are also counted but closed in the 2nd quarter (from April 1 - July 1) .
Is this even possible with jql?

Accepted answers

Dave Mathijs

@Alex Do you have multiple statuses for "closed tickets" or do you consider having a resolution as closed?

All comments

Dave Mathijs

@Alex Do you have multiple statuses for "closed tickets" or do you consider having a resolution as closed?

Alex_2nfdtf

Hi @Dave Mathijs , one status for "closed tickets"- resolution - Done.

Alex_2nfdtf

@Dave Mathijs

I thought the JQL script would work:

project in (TOPPROV, ABC) AND (created >= 2022-01-01 AND created <= 2022-07-01 AND assignee in (i.shangarev, t.petrakov) AND resolved >= 2022-04-01 AND resolved <= 2022-07-01)

but it didn't work out

Dave Mathijs

Try

project in (TOPPROV, ABC) AND (created >= 2022-01-01 AND created <= 2022-07-01) AND assignee in (i.shangarev, t.petrakov) AND (resolved >= 2022-04-01 AND resolved <= 2022-07-01)

project in (TOPPROV, ABC)

AND

(created >= 2022-01-01 AND created <= 2022-07-01)

AND

assignee in (i.shangarev, t.petrakov)

AND

(resolved >= 2022-04-01 AND resolved <= 2022-07-01)

If it doesn't work, try building up your query creating 1 clause, then adding another.