2.7JQL Tips and Tricks

Combine with Board Filters

Jira boards use JQL as their base filter. Customize your QA board:

-- QA board filter: Show items that need testing
project = SHOP AND (
  (type = Story AND status = "Ready for Test")
  OR (type = Bug AND assignee = currentUser() AND status = "In Verification")
  OR (type = "Test" AND sprint in openSprints())
)
ORDER BY priority DESC

Text Search

-- Search in summary and description
text ~ "payment timeout"

-- Search only in summary
summary ~ "checkout"

-- Search only in description
description ~ "NullPointerException"

-- Search in comments
comment ~ "cannot reproduce"

Performance Tips

• Use project = X early in the query to narrow the search space
• Avoid text ~ on large projects (slow full-text search)
• Use ORDER BY only when needed (adds processing time)
• Prefer labels over text search for categorization