You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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? :(
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
@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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SOLUTION!!! (slightly changed the script)
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 )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.