Two Great Jira Query Tricks

Q: “How can I find all the Jira tickets I touched in the last week?”

A: Three steps:

  1. Run a regular search in Jira.
  2. In the results screen, click Jira’s “Switch to JQL” link
    Screenshot of Jira showing the "Switch to JQL" link
  3. Once you’ve switched to JQL, run a query like the following:
    key IN updatedBy(ezra, -7d) ORDER BY key DESC
  • if your name isn’t Ezra, you probably want to modify the ezra part
  • if you want a timeframe other than the last 7 days, modify the -7d argument

Q: “How can I find all the Jira tickets in the current sprint?”

A: sprint IN currentSprints()

If, like me, you save queries and you don’t wanna constantly update the query to say sprint = 'Sprint 2' or sprint = 'Bugfix Sprint' or whatever, then sprint IN currentSprints() is your huckleberry

Leave a comment