JQL Related Advanced Search

[Michael Beal]

Is there a way to create a JQL to find all of the JIRA Issues that I personally moved from one status to another as well as any JIRA issues I added or participated in using Comments? Example: Our workflows move from "QA Review" to either "Product Acceptance or "Dev Ready" -- I want to know which ones I moved to either of these status. Within Comments, if I participated in anyway in a comment Yesterday or Today, how do I find those at the same time?

Further clarification -- I am wanting to find these items that occurred -1D from today or today. I don't want to find any of these issues that are more than 1 day in the past. Thank you

[Justin Leader · Accepted solution]

Sure!

Is there a way to create a JQL to find all of the JIRA Issues that I personally moved from one status to another

status was in ("Product Acceptance", "Dev Ready") by "username"

Within Comments, if I participated in anyway in a comment Yesterday or Today

For searching comments by a user, you'll likely need to use scriptrunner. See some more detailed directions here, but it seems like it would be something like:

issueFunction in commented ("by username after -2d")

So to see all those at the same time, I'd write this (note this won't work without the add-on described in the link above):

(status was in ("Product Acceptance", "Dev Ready") by "username") or (issueFunction in commented ("by username after -2d"))

[Justin Leader]

You're welcome. If it works, would you accept my answer for the system? Thanks!

[Michael Beal]

I'm looking into Script Runner now. Thank you