-- Everything assigned to me (open)
assignee = currentUser() AND resolution IS EMPTY

-- My issues in current sprint
assignee = currentUser() AND sprint IN openSprints()

-- Where I'm mentioned (last 7 days)
(text ~ currentUser() OR comment ~ currentUser()) AND updated >= -7d

-- Issues I'm watching
watcher = currentUser() AND resolution IS EMPTY

-- Reported by me, still open
reporter = currentUser() AND resolution IS EMPTY

-- Overdue
duedate < now() AND resolution IS EMPTY

-- Due this week
duedate >= startOfWeek() AND duedate <= endOfWeek()

-- Created today
created >= startOfDay()

-- Updated in last 24 hours
updated >= -24h

-- Created more than 30 days ago, still open
created <= -30d AND resolution IS EMPTY

-- Resolved last month
resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

-- No activity in 90 days
updated <= -90d AND resolution IS EMPTY

-- Was ever In Progress
status WAS "In Progress"

-- Currently Done, was In Progress at some point
status = "Done" AND status WAS "In Progress"

-- Status changed in the last 7 days
status CHANGED AFTER -7d

-- Moved to Done this week
status CHANGED TO "Done" AFTER startOfWeek()

-- Reopened issues (was resolved, now not)
status WAS IN ("Resolved", "Done", "Closed") AND resolution IS EMPTY

-- Current sprint
sprint IN openSprints()

-- Current sprint, specific project
sprint IN openSprints() AND project = "PROJ"

-- Backlog (not in any active/future sprint)
(sprint IS EMPTY OR sprint NOT IN (openSprints(), futureSprints())) 
AND resolution IS EMPTY AND project = "PROJ"

-- Completed in closed sprints (not carried over)
sprint IN closedSprints() AND sprint NOT IN openSprints() AND resolution IS NOT EMPTY

-- Added to sprint mid-sprint (requires status history)
sprint IN openSprints() AND NOT status WAS "To Do" ON startOfWeek()

-- All issues for a group
assignee IN membersOf("dev-team")

-- Unassigned in project
project = "PROJ" AND assignee IS EMPTY AND resolution IS EMPTY

-- Created by my team this month
reporter IN membersOf("dev-team") AND created >= startOfMonth()

-- High priority without assignee
priority IN (Highest, High) AND assignee IS EMPTY AND resolution IS EMPTY

-- All issues in an Epic
parent = PROJ-123

-- Issues without an Epic
parent IS EMPTY AND issuetype != Epic AND issuetype NOT IN subtaskIssueTypes()

-- All Epics without children
issuetype = Epic AND NOT parent = *

-- All issues in an Epic
"Epic Link" = PROJ-123

-- Issues without an Epic
"Epic Link" IS EMPTY AND issuetype != Epic AND issuetype NOT IN subtaskIssueTypes()

-- Subtasks of a specific parent
parent = PROJ-456

-- Word in summary
summary ~ "migration"

-- Exact phrase
summary ~ "\"database migration\""

-- In summary OR description
summary ~ "error" OR description ~ "error"

-- In comments only
comment ~ "workaround"

-- Multiple words (AND logic)
text ~ "deployment production failed"

-- Wildcard (words starting with)
summary ~ "API*"

-- Issues with attachments
attachments IS NOT EMPTY

-- Issues without components
component IS EMPTY AND project = "PROJ"

-- Flagged/impediment
flagged = Yes

-- Exclude subtasks from results
issuetype NOT IN subtaskIssueTypes()

-- Issues with external links
issueLink IS NOT EMPTY

-- Specific link type
issueLinkType = "blocks"

-- Slower (scans everything):
status = "Open"

-- Faster (scoped to project):
project = "PROJ" AND status = "Open"

-- Slow (searches all text fields):
text ~ "deployment"

-- Faster (searches specific fields):
summary ~ "deployment" OR description ~ "deployment"

-- Better:
status IN ("Open", "In Progress", "Review")

-- Worse:
status = "Open" OR status = "In Progress" OR status = "Review"

-- Forbidden and would be slow anyway:
summary ~ "*error"

-- OK:
summary ~ "error*"

-- Fast:
ORDER BY created DESC

-- Potentially slow:
ORDER BY "Custom Text Field" ASC