JQL Can't get all statuses

[Oliver Smith]

SHOWS ONLY CLOSED tickets (BY the condition I need *JQL below), BUT DOES NOT SHOW - "OPEN", "WAITING" etc.. (from April 1 to July 1)

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

*"receive all closed tickets (from April 1 to July 1), but in such a way that those that were submitted in Q1 (from January 1 to April 1) but closed in Q2 II (from April 1 to July 11) are taken into account ".    WHAT IS WRONG IN MY JQL? :(

[Bill Sheboy · Accepted solution]

Hi @Oliver Smith 

If all of the other query criteria apply, you could alter the query slightly to do that:

project IN (TOPPROV, ABC)
 AND (created >= 01/01/2022 AND created <= 07/01/2022)
 AND assignee IN (I.shangarev, t.petrakov) 
 AND (
      (resolved >= 04/01/2022 AND resolved <= 2022-07 -01)
      OR
       resolved IS EMPTY
     )

Kind regards,
Bill

[Oliver Smith]

@Bill Sheboy  Hi!)

WHERE "RESOLVED EMPTY" is a good solution... but the status (waiting to open..) should not count (from Jan 1-July 1)
:(
he must count from (from April 1-July 1)

all statuses except close should be considered for the second quarter)

[Oliver Smith]

SOLUTION!!! (slightly changed the script)

 @Bill Sheboy 

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)
OR project IN (TOPPROV, ABC) 
AND (created >= 2022-04-01 AND created <= 2022-07-01) 
AND assignee IN (i.shangarev, t.petrakov) AND resolved IS EMPTY )

[Oliver Smith]

@Bill Sheboy THANK YOU :)

[Vikram Sathish ASOKAN]

You can try the below 

project IN (TOPPROV, ABC)AND (created >= 01/01/2022 AND created <= 07/01/2022) AND assignee IN (I.shangarev, t.petrakov) AND ((resolved >= 04/01/2022 AND resolved <= 2022-07 -01)OR resolved IS EMPTY)

[William Hui]

Is this what you are looking for?

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