I need to get all closed tickets

[Alex]

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?

[Dave Mathijs · Accepted solution]

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

[Alex]

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

[Alex]

@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)

so

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.

[Alex]

Thank you !

[Alex]

@Dave Mathijs  Please tell me what should I add to the script so that it displays the rest of the statuses in the filter?

[Dave Mathijs]

Replace resolved by resolutiondate in your JQL query