Collection of Jira JQL

jira-quick-filters-jql.md

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")