Jira Snippet Library: JQL - Frequent Examples

Rachel Wright

Common use cases

Here are some single and multi-clause queries I use often.

Example	JQL	Use
Assigned to me	assignee = currentUser() AND statusCategory != Done ORDER BY created ASC	Items assigned to me, that need action, ordered by oldest creation date (ascending order)
Reported by me	reporter = currentUser() ORDER BY created DESC	Items I’ve requested or am the primary contact for listed in descending order
Created by me	creator = currentUser() ORDER BY created DESC	Items I created listed in descending order
“Stale” items	statusCategory != Done and status != Backlog AND updated <= -30d ORDER BY updated ASC	Items not done that haven’t been updated this month
Not resolved by the due date	statusCategory = "In Progress" AND status != "On Hold" and resolution is EMPTY AND due <= now()	Unresolved items with a “Due Date” in the past
Status changed this week	status CHANGED TO “To Do” AFTER startOfWeek() BEFORE endOfWeek()	Items currently in, or previously in a status, in the current week
Due this month or next	due >= startOfMonth() AND due <= endOfMonth(1)	Notice the “1” variable in the “endOfMonth(1)” function
Keyword or label	text ~ reimbursement OR labels = reimbursement	Items with “reimbursement” in the “Summary” (title), “Description”, “Comment”, or “Labels” field
With a specific label	labels = reimbursement	Items containing the specified label
Without a specific label	labels != reimbursement OR labels is EMPTY	Items not labeled “reimbursement.”  Don’t forget to include the “OR labels is EMPTY” clause!
Linked items	issue in linkedIssues(ITEM-123)	All items linked to ITEM-123
Linked items by link type	issue in linkedIssues(ITEM-123, “Relates To”)	All items related to ITEM-123
Parent links	parent = ITEM-123	All child items of ITEM-123

---

Back to intro or article list

Dave LIAO

@Rachel Wright - What do I love more than a snippet? A library of snippets!

Worth mentioning is that mileage may vary with certain queries, such as "Not resolved by the due date":

• There are Jira instances that mis-use (intentionally or accidentally) status categories for one or more statuses.
• Certain Jira instances may not have On Hold, or mis-use it, or have that status in a different language.