# Jira JQL Cheat Sheet: 20 Queries Every Team Needs July 29, 2026 · 5 min read [NGPilot](https://ngpilot.com) Quick Answer JQL (Jira Query Language) lets you search for issues using fields, operators, and values. Master 20 essential queries to find issues fast, track sprint health, and build custom dashboards. What you'll learn 1. The JQL syntax basics that power every query 2. 20 copy-paste queries for common searches 3. How to use JQL functions for dynamic, date-aware filters 4. How to save and share filters for dashboards Jira's search is powerful, but most teams only scratch the surface. They type a few keywords into the search bar, get overwhelmed by results, and give up. JQL — Jira Query Language — is the key to unlocking precise, repeatable searches that find exactly what you need. This cheat sheet covers 20 essential JQL queries, from basic field searches to advanced functions. Each query is copy-paste ready. ## JQL Syntax Basics[​](#jql-syntax-basics "Direct link to JQL Syntax Basics") Every JQL query follows this structure: ``` field operator value [AND|OR field operator value ...] ``` **Fields** are properties of issues: * `status` — current workflow state * `assignee` — who it is assigned to * `priority` — High, Medium, Low, etc. * `created` — when the issue was created * `updated` — when the issue was last modified * `summary` — the issue title * `text` — full-text search across all fields **Operators** compare fields to values: * `=` / `!=` — equals / not equals * `>` / `<` / `>=` / `<=` — greater/less than (for dates and numbers) * `~` / `!~` — contains / does not contain (for text fields) * `in` — matches any value in a list * `is` — used with EMPTY **Values** are the data you are searching for: * Strings: `"in progress"` (quoted if multi-word) * Dates: `2026-07-01` or relative: `-7d` (7 days ago) * Functions: `currentUser()`, `now()`, `startOfWeek()` ## 10 Essential JQL Queries[​](#10-essential-jql-queries "Direct link to 10 Essential JQL Queries") ### 1. Find all issues assigned to me[​](#1-find-all-issues-assigned-to-me "Direct link to 1. Find all issues assigned to me") ``` assignee = currentUser() ``` ### 2. Find all open issues in a project[​](#2-find-all-open-issues-in-a-project "Direct link to 2. Find all open issues in a project") ``` project = MYPROJECT AND status != Done ``` ### 3. Find issues created in the last 7 days[​](#3-find-issues-created-in-the-last-7-days "Direct link to 3. Find issues created in the last 7 days") ``` created >= -7d ``` ### 4. Find high-priority bugs[​](#4-find-high-priority-bugs "Direct link to 4. Find high-priority bugs") ``` priority = High AND issuetype = Bug ``` ### 5. Find issues updated in the last 3 days[​](#5-find-issues-updated-in-the-last-3-days "Direct link to 5. Find issues updated in the last 3 days") ``` updated >= -3d ``` ### 6. Find issues with no assignee[​](#6-find-issues-with-no-assignee "Direct link to 6. Find issues with no assignee") ``` assignee IS EMPTY AND status != Done ``` ### 7. Find issues blocked by another issue[​](#7-find-issues-blocked-by-another-issue "Direct link to 7. Find issues blocked by another issue") ``` issue in linkedIssues("BLOCKER-123", "is blocked by") ``` ### 8. Find all stories in the current sprint[​](#8-find-all-stories-in-the-current-sprint "Direct link to 8. Find all stories in the current sprint") ``` sprint in openSprints() AND issuetype = Story ``` ### 9. Find issues due this week[​](#9-find-issues-due-this-week "Direct link to 9. Find issues due this week") ``` due >= startOfWeek() AND due <= endOfWeek() ``` ### 10. Find issues you reported[​](#10-find-issues-you-reported "Direct link to 10. Find issues you reported") ``` reporter = currentUser() ``` ## 10 Advanced JQL Queries[​](#10-advanced-jql-queries "Direct link to 10 Advanced JQL Queries") ### 11. Find issues with no comments[​](#11-find-issues-with-no-comments "Direct link to 11. Find issues with no comments") ``` comment IS EMPTY AND status != Done ``` ### 12. Find issues updated by someone else recently[​](#12-find-issues-updated-by-someone-else-recently "Direct link to 12. Find issues updated by someone else recently") ``` updated >= -1d AND assignee = currentUser() AND reporter != currentUser() ``` ### 13. Find all epics with open stories[​](#13-find-all-epics-with-open-stories "Direct link to 13. Find all epics with open stories") ``` issuetype = Epic AND issueFunction in hasSubTask("status != Done") ``` ### 14. Find issues with a specific label[​](#14-find-issues-with-a-specific-label "Direct link to 14. Find issues with a specific label") ``` labels = "needs-review" ``` ### 15. Find issues created this month[​](#15-find-issues-created-this-month "Direct link to 15. Find issues created this month") ``` created >= startOfMonth() ``` ### 16. Find issues with high story points[​](#16-find-issues-with-high-story-points "Direct link to 16. Find issues with high story points") ``` cf[10002] >= 8 ``` ### 17. Find issues not updated in 14 days[​](#17-find-issues-not-updated-in-14-days "Direct link to 17. Find issues not updated in 14 days") ``` updated <= -14d AND status != Done ``` ### 18. Find all sub-tasks of a specific issue[​](#18-find-all-sub-tasks-of-a-specific-issue "Direct link to 18. Find all sub-tasks of a specific issue") ``` parent = "PROJ-123" ``` ### 19. Find issues with a specific fix version[​](#19-find-issues-with-a-specific-fix-version "Direct link to 19. Find issues with a specific fix version") ``` fixVersion = "v2.1.0" ``` ### 20. Find issues in multiple projects[​](#20-find-issues-in-multiple-projects "Direct link to 20. Find issues in multiple projects") ``` project in (PROJECT_A, PROJECT_B) AND status = "In Progress" ``` ## How to Save and Share Filters[​](#how-to-save-and-share-filters "Direct link to How to Save and Share Filters") Once you have a useful query, save it as a filter: 1. Run your JQL query in the search bar 2. Click **Save as** in the top right 3. Name the filter (e.g., "My Open Issues") 4. Choose **Private** or **Shared** visibility 5. Click **Save** **Use saved filters in:** * Dashboards (Filter Results gadget) * Boards (configure board filter) * Subscriptions (daily email of matching issues) * Quick filters on your board ## FAQ[​](#faq "Direct link to FAQ") ### What is JQL in Jira?[​](#what-is-jql-in-jira "Direct link to What is JQL in Jira?") JQL stands for Jira Query Language. It is a structured query language used to search for issues in Jira. JQL uses fields (like status, assignee, priority), operators (like =, !=, >, <), and values to build precise search queries. ### How do I find all issues assigned to me?[​](#how-do-i-find-all-issues-assigned-to-me "Direct link to How do I find all issues assigned to me?") Use the query: assignee = currentUser(). This dynamically finds all issues assigned to the currently logged-in user regardless of project or status. ### How do I search for issues created in the last 7 days?[​](#how-do-i-search-for-issues-created-in-the-last-7-days "Direct link to How do I search for issues created in the last 7 days?") Use: created >= -7d. The -7d syntax means '7 days ago from today.' You can also use -1w for one week or -1m for one month. ### Can I use JQL in Jira dashboards?[​](#can-i-use-jql-in-jira-dashboards "Direct link to Can I use JQL in Jira dashboards?") Yes. Save a JQL query as a filter, then use the filter in dashboard gadgets like Filter Results, Assigned to Me, or Two Dimensional Statistics. The gadget re-runs the query automatically. ### What is the difference between JQL and SQL?[​](#what-is-the-difference-between-jql-and-sql "Direct link to What is the difference between JQL and SQL?") JQL is specifically designed for Jira issue searching and uses a simplified syntax. SQL is a general-purpose database language. JQL uses field names and operators rather than tables and joins. ## Related guides[​](#related-guides "Direct link to Related guides") * [How to Plan Jira Sprints That Actually Work](/blog/plan-jira-sprints-that-actually-work.md) * [How to Set Up Jira Dashboards for Sprint Tracking](/blog/jira-dashboard-sprint-tracking-setup.md) * [Export Jira Issues to Excel for Stakeholder Reporting](/blog/export-jira-issues-to-excel-csv-reporting.md) * [How to Export Jira Audit Logs for Compliance](/blog/export-jira-audit-logs-compliance.md) ## Related guides * [How to Create Mermaid Diagrams in Jira](/blog/how-to-create-mermaid-diagrams-jira.md) * [Export Jira Issues to Excel or CSV](/blog/export-jira-issues-to-excel.md) * [Bulk Download Jira Attachments](/blog/bulk-download-jira-attachments.md) * [How to Migrate Confluence Content](/blog/how-to-migrate-confluence-content.md) Explore NGPILOT[Browse Solutions](/solutions.md)[All Apps](/apps.md)[Atlassian Marketplace →](https://marketplace.atlassian.com/vendors/1226848/?utm_source=ngpilot.com\&utm_medium=blog\&utm_campaign=hub-links) **Tags:** * [jira](/blog/tags/jira.md) * [jql](/blog/tags/jql.md) * [how-to](/blog/tags/how-to.md) * [queries](/blog/tags/queries.md) * [reporting](/blog/tags/reporting.md)