How to filter the tickets status changed from IN QA to Done by any member of the project?

Syed Abdul Basit September 12, 2022

I would like to filter out tickets in a release that would be closed by QA team and tickets status moved from "IN QA" to "Done".

 

Can anyone help me with the JQL. 

 

project = ABC AND fixVersion = 10.0.1 AND status changed from "IN QA" TO "DONE" AND status changed BY currentuser()

3 answers

2 accepted

1 vote
Answer accepted
Alexander Bondarev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 12, 2022

Hi, @Syed Abdul Basit !

If all QA-members have jira group like "QA-team", you can use the JQL like that:

project = ABC AND fixVersion = 10.0.1 AND status changed from "IN QA" TO "DONE" AND status changed BY (membersof("qa-team"))

0 votes
Answer accepted
Syed Abdul Basit September 12, 2022

Also, would like to know the possible methods of using the BY command.

Syed Abdul Basit September 12, 2022

@Alexander Bondarev can you help?

Alexander Bondarev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2022

Hi @Syed Abdul Basit !

In the context of the JQL operator "Changed" you can read the official documentation.

Like Syed Abdul Basit likes this
Alexander Bondarev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2022

The "CHANGED" operator is used to find issues that have a value that had changed for the specified field.

This operator has the following optional predicates:

  • AFTER "date"
  • BEFORE "date"
  • BY "username"
  • DURING ("date1","date2")
  • ON "date"
  • FROM "oldvalue"
  • TO "newvalue"

(Note: This operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only.)

Syed Abdul Basit September 14, 2022

Thanks Alexander. In Jira, the username would be the profile name?

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 12, 2022

Hi Syed,

What exactly is your question? What does not work with the query you have? What is the exact scenario?

Syed Abdul Basit September 12, 2022

Instead of using currentuser() function, I would like to filter by resource name

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events