Skip to content

Instantly share code, notes, and snippets.

@mvsantos
Last active February 11, 2023 21:57
Show Gist options
  • Save mvsantos/e9b2530a97a6345c2668116ffefeeded to your computer and use it in GitHub Desktop.
Save mvsantos/e9b2530a97a6345c2668116ffefeeded to your computer and use it in GitHub Desktop.
Collection of Jira JQL

URGENT

(priority IN (Critical, High) OR (duedate >= "-7d" AND duedate <= "7d"))

Blocked

Flagged IS NOT EMPTY

Bugs

type = Bug AND labels NOT IN (defect, defects)

Defects

type = Bug AND labels IN (defect, defects)

Due Date (1m)

duedate <= "1m"

Due Date (2w)

duedate <= "2w"

Me (Assignee)

assignee = currentUser()

Me (Comment)

issueFunction in commented("by currentUser()")

Me (Reporter)

reporter = currentUser()

Me (Reviewer)

Reviewer = currentUser()

Me (Watching)

watcher = currentUser()

PRs Open

development[pullrequests].open > 0

Issues with open pull-requests

PRs Merged/Declined

development[pullrequests].all > 0 AND development[pullrequests].open = 0

Issues with merged or declined pull-requests

PRs None

development[pullrequests].all = 0

Issues with no pull-requests

Recently Updated

updatedDate >= -1d

Displays issues which have been updated in the last day

Sprint Committed

issueFunction not in addedAfterSprintStart("INSERT YOUR BOARD NAME HERE")

Sprint Injections

issueFunction in addedAfterSprintStart("INSERT YOUR BOARD NAME HERE")

Status Changed (1d)

status CHANGED AFTER startOfDay("-1d")

Issues with status changes since yesterday

Status Changed (3d)

status CHANGED AFTER startOfDay("-3d")

Issues with status changes in the past 3 days

Status Changed (7d)

status CHANGED AFTER startOfDay("-7d")

Issues with status changes in the past 7 days

Status Stuck 2d

NOT status CHANGED DURING(endOfDay("-3d"), now())

Status Stuck 3d+

NOT status CHANGED AFTER startOfDay("-3d")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment