66 Jira Cloud JQL queries that actually parse

Published 2026-09-24 by Sidecar Tools. Every query below was submitted to Jira Cloud's strict JQL parser on 2026-09-24 and returned no errors.

Most JQL lists online were written for Jira Server and quietly break on Cloud. This is the free sample of The Jira Cloud JQL Cookbook: 66 queries across nine sections, each one run through /rest/api/3/jql/parse?validation=strict with real values before it was allowed in. Ten of them are below, in full.

Ten queries you can paste now

Unassigned open work in my projects

assignee is EMPTY AND statusCategory != Done AND project in projectsWhereUserHasPermission("Edit Issues") ORDER BY created DESC

Created in the last 24 hours

created >= -24h ORDER BY created DESC

Created this week, still open

created >= startOfWeek() AND statusCategory != Done ORDER BY priority DESC, created ASC

High and highest priority, not yet started

priority in (High, Highest) AND statusCategory = "To Do" ORDER BY priority DESC, created ASC

Reported by customers via the portal (JSM)

project = SUP AND "Request Type" is not EMPTY AND statusCategory != Done ORDER BY created ASC

Replace SUP with your service project key.

Work items with no description

description is EMPTY AND statusCategory != Done ORDER BY created DESC

Work items with no priority set

priority is EMPTY AND statusCategory != Done

Bugs opened in the last 7 days

type = Bug AND created >= -7d ORDER BY priority DESC

Open and untouched for 14 days

statusCategory != Done AND updated <= -14d ORDER BY updated ASC

In progress for more than 30 days

statusCategory = "In Progress" AND status changed to "In Progress" before -30d AND statusCategory != Done ORDER BY updated ASC

What the full cookbook covers

Get the full cookbook (66 queries, PDF + searchable HTML, free updates, 30-day refund): The Jira Cloud JQL Cookbook on Gumroad, pay what you want from $12.