Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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

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

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

Hi @Syed Abdul Basit !

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

Like Syed Abdul Basit likes this

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

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

0 votes
John Funk Community Leader Sep 12, 2022

Hi Syed,

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

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

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events