I would like to check, who started working on new issue while there were issues waiting for CR

[michal.gruda]

Basically, as title says:

I would like to check, who started working on new issue while there were issues waiting for code review.

For that I would write a JQL query like this:

Project = XXX AND status changed to "In Progrees" when there were issues having status "Ready for testing" 

Providing there was functional equivalent of bolded keywords. Possible in JQL with or without a plugin?

Thanks,

Michal

[Kristján Geir Mathiesen · Accepted solution]

Hi @michal.gruda 

Well, I believe you could achive this by intersecting 2 filters.

Create the first filter:

Project = XXX AND status changed to "In Progress" DURING ("2023/02/01","2023/02/10")

and save it as "Filter A"

Then create another filter like this:

Project = XXX AND status changed to "Ready for testing" DURING ("2023/02/01","2023/02/10") AND filter = "Filter A"

Both time periods have to match up.

HTH,
KGM

[michal.gruda]

Hi Kristjan,

Thanks for your answer!

This is exactly what I did. But wasn't happy with additional manual work I had to put into it, to find exact pairs - dev A - staret issue X, when there was issue Z waiting for test. Additionally, I need to filter out manually false positives from the two lists. 

1. Dev A started to work on issue Y after putting issue X in "Ready for test". This is a false positive, as the same dev cannot implement a solution and make code review of her/his own work.

2. Dev S (like Special) can open issues when there issues for testing, as his area of expertise is defined, specific, and narrow.

I am looking for a solution, that cross-applies the two filters with above rules, without spending half an hour daily for error-prone eyeballs check. Do you think it is possible with JQL with / without a plugin?

Many thanks,

Michal