Skip to content
Wm logo graphic Work Management Hub

Expert Reviews, Comparisons & Guides for Smartsheet, Monday.com, Asana, ClickUp & More

Wm logo graphic Work Management Hub

Expert Reviews, Comparisons & Guides for Smartsheet, Monday.com, Asana, ClickUp & More

  • Comparisons
  • Pricing
  • Alternatives
  • How-To Guides
  • Tools
    • Smartsheet
    • Monday.com
    • Asana
    • ClickUp
    • Notion
    • Jira
    • Wrike
    • Airtable
  • About
  • Comparisons
  • Pricing
  • Alternatives
  • How-To Guides
  • Tools
    • Smartsheet
    • Monday.com
    • Asana
    • ClickUp
    • Notion
    • Jira
    • Wrike
    • Airtable
  • About
Close

Search

Table of common JQL operators and when to use them
How-To GuidesJira

Jira JQL 2026: Advanced Filters, Boards & Queries That Stay Fast

Photo of Khasim Basha Shaik
By Khasim Basha Shaik
June 1, 2026 4 Min Read
0

Home - How-To Guides - Jira JQL 2026: Advanced Filters, Boards & Queries That Stay Fast

Jira Query Language (JQL) is how you find work items in Jira Cloud when basic search is not enough. You type field-operator-value clauses in advanced search, save them as filters, and point boards, queues, dashboards, and automation at those filters. Done well, JQL is the difference between a board that shows the sprint and a board that shows noise.

I implement Atlassian and Smartsheet stacks for delivery teams. The JQL mistakes I clean up are rarely exotic syntax – they are unbounded OR trees, text searches on huge projects, and filters nobody owns after the author leaves. This guide is the practical subset: structure, operators that matter, board filters, and performance habits. Syntax details follow Atlassian’s advanced search / JQL docs, checked October 14, 2026.

Seat prices moved on October 13, 2026. For the 1-100 user monthly band, list pricing is about $9.70 (Standard) and $19.60 (Premium) per user/month – confirm on Jira pricing and our Jira pricing guide. Free still covers up to 10 users.

Table of Contents

Toggle
  • The shape of a JQL clause
  • Operators and fields you will actually use
  • Board filters and quick filters
  • Performance habits that keep Cloud responsive
  • Examples worth saving
  • JQL vs basic search
  • Common questions
    • What is JQL in Jira?
    • How do I open JQL search in Jira Cloud?
    • Can JQL query custom fields?
    • Why is my JQL so slow?
  • Related guides

The shape of a JQL clause

Every clause is field + operator + value (sometimes a function):

text project = PROD AND status != Done AND assignee = currentUser() ORDER BY priority DESC, updated DESC

  • AND / OR / NOT combine clauses. Use parentheses when you mix AND and OR.
  • List operators: IN, NOT IN.
  • Empty checks: IS EMPTY, IS NOT EMPTY.
  • Text: ~ (contains) and !~ – powerful and easy to make slow.
  • Functions: currentUser(), now(), startOfDay(), membersOf("jira-developers"), openSprints(), closedSprints().

Save anything you reuse as a filter. Boards and dashboards should reference the saved filter, not a one-off query pasted into five places.

Table of common JQL operators and when to use them
Start with equality and IN before you reach for text search. Chart: WorkManagementHub.

Operators and fields you will actually use

NeedPatternNotes
One projectproject = KEYPrefer project-scoped filters for boards
Several projectsproject IN (A, B, C)Better than long OR chains
Active sprint worksprint IN openSprints()Scrum boards
My open workassignee = currentUser() AND resolution IS EMPTYPersonal queues
Recently updatedupdated >= -7dRelative dates
Empty assigneeassignee IS EMPTYTriage
Linked epicsparent = KEY-1 or Epic Link field (classic)Depends on team vs company-managed
Text summarysummary ~ "checkout"Index-backed; still costlier than IDs

Atlassian’s field reference in the JQL docs lists every field your site exposes, including custom fields (often as cf[12345]). Prefer the human-readable name when Jira offers it in the picker.

Board filters and quick filters

Company-managed boards use a board filter (saved JQL) plus optional quick filters (extra clauses ANDed when selected). Keep the board filter stable – usually project = KEY ORDER BY Rank ASC – and put temporary views in quick filters (assignee = currentUser(), priority = Highest).

Bad pattern: stuffing every reporting nuance into the board filter so the board loads slowly and nobody dares edit it. Good pattern: thin board filter, named quick filters, separate dashboard filters for leadership reports.

For Git-linked development work, pair board JQL with the Jira-GitHub integration so commits show on the work item while JQL still keys off status and sprint.

Performance habits that keep Cloud responsive

  1. Constrain by project first. project = X AND … beats scanning the whole site.
  2. Prefer IDs and dropdowns over ~ text when you can.
  3. Avoid huge OR trees. status IN (A,B,C) beats three ORs.
  4. Watch ORDER BY on heavy fields for dashboard gadgets that refresh often.
  5. Do not point automation at a filter that returns thousands of hits every few minutes – step usage adds up under the new metering (see Jira automation rules and Atlassian automation licensing).
Whiteboard with sticky notes for sprint planning
Thin board filters; put experiments in quick filters. Photo: Wikimedia Commons.

Examples worth saving

Sprint board backlog hygiene

text project = PROD AND sprint IN openSprints() AND type IN (Story, Bug, Task) ORDER BY Rank ASC

Unassigned high priority this week

text project = PROD AND priority IN (Highest, High) AND assignee IS EMPTY AND created >= -7d AND resolution IS EMPTY

Released this version

text project = PROD AND fixVersion = "2026.10" AND status = Done ORDER BY resolved DESC

Only my blocking issues

text assignee = currentUser() AND priority = Highest AND resolution IS EMPTY ORDER BY updated ASC

Test in Filters → Advanced issue search, then Save filter with a clear name (PROD · Open sprint, not Filter 18). Share with the project role that needs it; orphaned private filters break boards when people leave.

JQL vs basic search

Basic search is fine for “find KEY-123” or a single field. Use JQL when you need reproducible queues, board scopes, shared reports, or automation conditions. If your team lives in spreadsheets instead, you may want a lighter tool – but for software delivery, JQL plus boards is still the native path. Broader tool context: best project management software 2026.

Common questions

What is JQL in Jira?

Jira Query Language is the advanced search syntax for filtering work items by fields, operators, and functions. You use it in advanced search, saved filters, boards, and some automation conditions.

How do I open JQL search in Jira Cloud?

Go to Filters → Advanced issue search (wording can vary slightly by UI layout). Switch to JQL if you land in basic search, then type your query.

Can JQL query custom fields?

Yes. Use the field name the picker suggests, or the cf[id] form from Atlassian’s field reference when names collide.

Why is my JQL so slow?

Usually an unbounded query (no project), heavy text search (~), or a huge result set feeding a board or gadget. Narrow by project, replace text search with exact fields, and save a thinner filter.

JQL behavior checked against Atlassian Support advanced-search docs on October 14, 2026. Cloud list prices changed October 13, 2026 – confirm on Atlassian’s pricing calculator.

Sponsored

OneSMAR for Smartsheet Teams - Available on the App Store

Related guides

How to Create Jira Dashboards and Use Gadgets in 2026: Setup, Best Gadgets and Fixes
Jira
How to Create Jira Dashboards and Use Gadgets in 2026: Setup, Best Gadgets and Fixes
Jira vs Linear in 2026: Real Prices, Sprint Tools and How to Pick for Your Dev Team
Jira
Jira vs Linear in 2026: Real Prices, Sprint Tools and How to Pick for Your Dev Team
Jira vs Asana in 2026: Prices, AI Limits and an Honest Pick for Each Team
Asana
Jira vs Asana in 2026: Prices, AI Limits and an Honest Pick for Each Team
Photo of Khasim Basha Shaik
Author

Khasim Basha Shaik

Khasim is a work management expert and entrepreneur with a deep passion for project management tools. He works hands-on with platforms like Smartsheet, Monday.com, Asana, ClickUp, Jira, Notion, Wrike and Airtable every day, and loves automating workflows to save teams and customers a ton of time. On WorkManagementHub he shares practical setup guides, honest tool comparisons, and real-world troubleshooting drawn from daily use.

Follow Me
Other Articles
Table of Notion permission levels from Full access to Can view and where each one applies
Previous

Notion Permissions Not Working? Real Causes and Fixes

Small team working together on laptops on a couch
Next

Wrike vs Teamwork.com 2026: Which Is Better for Agencies and Client Work?

No Comment! Be the first one.

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    KB
    Khasim Basha Shaik

    Khasim is a work management expert and entrepreneur with a deep passion for project management tools. He works hands-on with platforms like Smartsheet, Monday.com, Asana, ClickUp, Jira, Notion, Wrike and Airtable every day, and loves automating workflows to save teams and customers a ton of time. On WorkManagementHub he shares practical setup guides, honest tool comparisons, and real-world troubleshooting drawn from daily use.

    About Work Management Hub →

    Popular reviews & guides

    • Table matching ten team types to the project management tool to start with, a runner-up and the reasonBest Project Management Software 2026: 10 Tools Compared by Team Type, Real Monthly Cost and the Limits That Matter
    • Team meeting around a long conference table with laptops openJira Pricing 2026: Standard vs Premium, Annual Tiers and the Oct 13 Increase
    • Developer working on a laptop with code on screen while holding a phoneJira Slack Integration 2026: Setup, @Jira Tickets and Channels Without the Noise
    • Laptop covered in developer stickers on a deskLinear vs GitHub Issues (2026): Who Should Track the Work?
    • Person typing on a laptop at a small round tableLinear-GitHub Sync Broken? Fix Every Failure Mode
    • Three people collaborating around a laptop at a meeting tableGitHub Stacked PRs Are GA: What Changed Oct 6, 2026 (and How to Roll Them Out)

    Browse by tool

    • Smartsheet33
    • Monday.com28
    • Asana33
    • ClickUp30
    • Notion29
    • Jira31
    • Wrike16
    • Airtable16
    • Integrations12

    Sponsored OneSMAR – Everything you need for Smartsheet in one place

    Independent reviews, comparisons, and hands-on guides for work management tools — Smartsheet, Monday.com, Asana, ClickUp, Notion, Jira, Wrike, and Airtable — written from daily, real-world use of these platforms.

    Tools We Cover

    • Smartsheet
    • Monday.com
    • ClickUp
    • Asana
    • Notion
    • Jira
    • Wrike
    • Airtable

    Company

    • About Us
    • Contact Us
    • Privacy Policy
    • Terms of Use
    • Disclaimer
    • Affiliate Disclosure
    Copyright 2026 — Work Management Hub. All rights reserved. Blogsy WordPress Theme