JQL Examples

Common JQL (Jira Query Language) patterns for use with the GoJira CLI and SDK.

Basic Queries

By Project

# Single project
gojira search --jql "project = FOO"

# Multiple projects
gojira search --jql "project in (FOO, BAR, BAZ)"

By Status

# Single status
gojira search --jql "status = Open"

# Multiple statuses
gojira search --jql "status in (Open, 'In Progress', 'In Review')"

# Exclude statuses
gojira search --jql "status not in (Done, Closed)"

By Type

# Bugs only
gojira search --jql "issuetype = Bug"

# Multiple types
gojira search --jql "issuetype in (Bug, Task, Story)"

By Assignee

# Current user
gojira search --jql "assignee = currentUser()"

# Specific user
gojira search --jql "assignee = 'john.doe'"

# Unassigned
gojira search --jql "assignee is EMPTY"

Combining Conditions

AND

gojira search --jql "project = FOO AND status = Open AND type = Bug"

OR

gojira search --jql "project = FOO AND (status = Open OR status = 'In Progress')"

Date Queries

Relative Dates

# Created in last 7 days
gojira search --jql "created >= -7d"

# Updated in last 24 hours
gojira search --jql "updated >= -1d"

# Due in next 3 days
gojira search --jql "due <= 3d"

Absolute Dates

# Created after date
gojira search --jql "created >= '2024-01-01'"

# Created between dates
gojira search --jql "created >= '2024-01-01' AND created <= '2024-01-31'"

Date Functions

# Created this week
gojira search --jql "created >= startOfWeek()"

# Due this month
gojira search --jql "due >= startOfMonth() AND due <= endOfMonth()"

# Updated this year
gojira search --jql "updated >= startOfYear()"

Text Search

Full Text

# Search all text fields
gojira search --jql "text ~ 'error'"

# Exact phrase
gojira search --jql 'text ~ "connection timeout"'

Summary Only

gojira search --jql "summary ~ 'login'"

Description Only

gojira search --jql "description ~ 'reproduction steps'"

Priority and Resolution

By Priority

# High priority
gojira search --jql "priority = High"

# High or Critical
gojira search --jql "priority in (High, Highest, Critical)"

By Resolution

# Unresolved
gojira search --jql "resolution is EMPTY"

# Resolved
gojira search --jql "resolution is not EMPTY"

# Won't Fix
gojira search --jql "resolution = 'Won\\'t Fix'"

Sprint and Version

Sprint

# Current sprint
gojira search --jql "sprint in openSprints()"

# Specific sprint
gojira search --jql "sprint = 'Sprint 42'"

# Future sprints
gojira search --jql "sprint in futureSprints()"

Fix Version

# Specific version
gojira search --jql "fixVersion = '1.0'"

# No fix version
gojira search --jql "fixVersion is EMPTY"

# Released versions
gojira search --jql "fixVersion in releasedVersions()"

Labels

# Has label
gojira search --jql "labels = bug"

# Has any of these labels
gojira search --jql "labels in (bug, urgent, production)"

# No labels
gojira search --jql "labels is EMPTY"

Components

# In component
gojira search --jql "component = Backend"

# Multiple components
gojira search --jql "component in (Backend, API)"

Custom Fields

# By custom field ID
gojira search --jql "cf[10001] = 'Value'"

# By custom field name (if unique)
gojira search --jql "'Story Points' >= 5"

# Custom field is empty
gojira search --jql "cf[10001] is EMPTY"

Parent/Child Relationships

Epics

# Issues in an epic
gojira search --jql "'Epic Link' = FOO-100"

# Issues with no epic
gojira search --jql "'Epic Link' is EMPTY"

Sub-tasks

# Sub-tasks of an issue
gojira search --jql "parent = FOO-123"

# All sub-tasks in project
gojira search --jql "project = FOO AND issuetype = Sub-task"

Ordering and Limiting

ORDER BY

# Order by priority (descending)
gojira search --jql "project = FOO ORDER BY priority DESC"

# Order by created date
gojira search --jql "project = FOO ORDER BY created ASC"

# Multiple order fields
gojira search --jql "project = FOO ORDER BY priority DESC, created ASC"

Limiting Results

# First 10 results
gojira search --jql "project = FOO" --max 10

# All results
gojira search --jql "project = FOO" --all

Complex Examples

Open High-Priority Bugs

gojira search --jql "project = FOO AND type = Bug AND priority in (High, Highest) AND status != Done"

My Overdue Tasks

gojira search --jql "assignee = currentUser() AND due < now() AND resolution is EMPTY"

Recently Updated in Sprint

gojira search --jql "sprint in openSprints() AND updated >= -1d ORDER BY updated DESC"

Blockers and Critical Issues

gojira search --jql "project = FOO AND (priority = Blocker OR labels = critical) AND resolution is EMPTY"

Stale Issues

# Not updated in 30 days, still open
gojira search --jql "project = FOO AND updated <= -30d AND status not in (Done, Closed)"

JQL Builder (SDK)

Use the SDK's JQL builder for programmatic query construction:

import "github.com/grokify/gojira"

jql := gojira.JQL{
    ProjectsIncl: [][]string{{"FOO"}},
    TypesIncl:    [][]string{{"Bug"}},
    StatusesExcl: [][]string{{"Done", "Closed"}},
}

query := jql.String()
// project = 'FOO' AND type = 'Bug' AND status NOT IN ('Done', 'Closed')

See JQL Builder for more details.