Want to query all defects opened by me but placed in (omit, deferred, or closed) by someone else

Question

It's probably not possible but I ask the community.  The best I can do is identify those bugs which have been placed into that state but my manager is asking for a list of defects not closed by me (and another team member).  The query I'm using to at least identify those bugs in the previously mentioned states is:

project in (PSCALE) AND type = Defect AND (reporter in (XXXXX, YYYYY)) AND status changed to (deferred, omit, closed) order by key DESC

I don't see anyway to see how to query the history of the defect not to mention identifying who put it in one of those final states. It would be great if I could identify the user(s) who transitioned the states.

What's the secret sauce??

Daniel Ebers · Answer

Hi @Todd Holman

in the following query there might be missing a thing because I fully believe Ismael when he says it is not possible out of the box - but anyways, currently not seeing _what_ could be missing as in a test instance it seemed to bring up the correct results ... so you could at least give the following a try if you want to:

reporter = currentuser() AND status IN (Resolved, Closed) AND NOT status changed to (closed) by currentuser()

Happy to hear what is overlooked in terms of a correct/full solution.

Regards,
Daniel

Todd Holman · Answer

The problem is I won't know which user transitioned it.  We have a lot of engineers spread around the globe.  I want to find the names of those who have moved it from currentuser() or reporter to one of the end states.  I can't very easily plug in a hundred (for example) users in the clause 'status changed to (deferred, omit, closed) by some_other_user'.  So this is at least something but it does seem the query I want based on Ismael's response is not possible. Thank you.

Piotr Zadrożny _Eyzee_ · Answer

Oh sorry I misunderstood your question. Try something like this:

(status was in (Omit, Closed)) AND (status was not in (Omit, Closed) by XXX)