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; } } }

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

Accepted answers

Syed Abdul Basit

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

Alexander Bondarev_x6gjf3

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

All comments

Syed Abdul Basit

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

John Funk

Hi Syed,

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

Alexander Bondarev_x6gjf3

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

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

Syed Abdul Basit

@Alexander Bondarev can you help?

Alexander Bondarev_x6gjf3

Hi @Syed Abdul Basit !

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

Alexander Bondarev_x6gjf3

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud