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

[Syed Abdul Basit]

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

[Alexander Bondarev · Accepted solution]

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

[Syed Abdul Basit · Accepted solution]

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

[Syed Abdul Basit]

@Alexander Bondarev can you help?

[Alexander Bondarev]

Hi @Syed Abdul Basit !

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

[Alexander Bondarev]

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]

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

[John Funk]

Hi Syed,

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

[Syed Abdul Basit]

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