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 Can't get all statuses

Alex_2nfdtf

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?

Accepted answers

Bill Sheboy

Hi @Alex

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

All comments

Bill Sheboy

Hi @Alex

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

Alex_2nfdtf

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

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

Alex_2nfdtf

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 )

Alex_2nfdtf

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