Please, how can I create sorting by particular QA tester inside of this query

[Dmytro Reva]

Please, how can I create sorting by particular QA tester inside of this query

PROJECT = Ecommerce AND (STATUS WAS "QA Testing" AFTER "2019/08/15") AND (STATUS WAS "QA Testing" BEFORE "2022/11/20")  ? Thanks!

[John Funk]

Hi Dmitri,

What do you mean by sorting "by a particualar QA tester"? Do you just mean sort by the QA Tester field? (Assuming you have a custom field by that name)

[Dmytro Reva]

Hi John, I mean if there are multiple QA testers were involved within a given period (all of them are QA Tester), then how to sort by QA Tester John and QA Tester Dmitri?

[John Funk]

Just don an Order by on that field and it will group all the testers by name. 

PROJECT = Ecommerce AND (STATUS WAS "QA Testing" AFTER "2019/08/15") AND (STATUS WAS "QA Testing" BEFORE "2022/11/20") ORDER by "QA Tester"

Or whatever the actual field name is where you are storing the tester's name. 

[Dmytro Reva]

Maybe better to rephrase my request a such way: how can I query to find in how many tickets I was as a QA Tester within a given period?

[John Funk]

Oh, for that I would save your filter above. Then create a Dashboard with a gadget for Issue Statistics. Use the QA Tester field for your Issue Statisic. This will group by the name and give you a count by user. 

This assumes the field is a user picker custom field and not a text field. 

[Trudy Claspill]

Does the value of QA Tester change?

@John Funk 's suggestion will show you metrics based on the current value of QA Tester. It won't show you metrics that show you were QA Tester on Issue ABC-123 at some point but somebody else is currently QA Tester.

[Dmytro Reva]

@John Funkthanks indeed!

[John Funk]

You are welcome.  :-)