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

[Todd Holman]

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??

[Piotr Zadrożny _Eyzee_]

Hi @Todd Holman 

You can use more extended version of changed operator like:

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

Check this documentation.

Best regards,

Piotr

[Piotr Zadrożny _Eyzee_]

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

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

[Todd Holman]

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.

[Daniel Ebers]

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

[Ismael Jimoh]

Hi @Todd Holman 

Welcome to the community.

To my knowledge, the above request which includes who put the issue to the status is not possible out of the box. While Jira stores this in the issue history unless you explicitly store it in a custom field, you cannot perform a search with your conditions.

Regards