JQL Query Builder

Expert assistance for constructing JQL (Jira Query Language) queries to search and filter Jira issues efficiently.

When to Use This Skill

• User wants to search for specific issues
• User needs to filter issues by multiple criteria
• User mentions JQL or queries
• User wants to find bugs, features, or tasks matching certain conditions
• User needs help understanding JQL syntax

JQL Basics

Field Operators

=

status = "In Progress"

!=

priority != Low

>

<

created > -7d

>=

<=

priority >= High

~

summary ~ "login"

IN

status IN (Open, "In Progress")

NOT IN

priority NOT IN (Low)

IS EMPTY

assignee IS EMPTY

IS NOT EMPTY

dueDate IS NOT EMPTY

Common Fields

• project: Project key (e.g.,

  project = PROJ

  )
• status: Issue status (e.g.,

  status = "In Progress"

  )
• priority: Priority level (e.g.,

  priority = High

  )
• assignee: Assigned user (e.g.,

  assignee = currentUser()

  )
• reporter: Who created it (e.g.,

  reporter = currentUser()

  )
• created: Creation date (e.g.,

  created >= -30d

  )
• updated: Last update (e.g.,

  updated > -7d

  )
• type: Issue type (e.g.,

  type = Bug

  )
• labels: Labels (e.g.,

  labels = urgent

  )
• summary: Title text (e.g.,

  summary ~ "authentication"

  )
• description: Description text (e.g.,

  description ~ "error"

  )

Date Functions

• -1d

  ,

  -7d

  ,

  -30d

  : Relative dates (days ago)

• -1w

  ,

  -4w

  : Weeks ago

• startOfDay()

  ,

  endOfDay()

  : Day boundaries

• startOfWeek()

  ,

  endOfWeek()

  : Week boundaries

User Functions

• currentUser()

  : The logged-in user

• membersOf("group-name")

  : Users in a group

Logical Operators

• AND

  : Both conditions must be true

• OR

  : Either condition must be true

• NOT

  : Negate a condition

Common Query Patterns

My Open Issues

assignee = currentUser() AND status != Done

Recently Updated Bugs

type = Bug AND updated >= -7d ORDER BY updated DESC

High Priority Unassigned Issues

priority = High AND assignee IS EMPTY AND status != Done

Issues Created This Sprint

project = PROJ AND created >= -14d AND type IN (Story, Task)

Overdue Issues

dueDate < now() AND status != Done ORDER BY dueDate ASC

Issues Mentioning Specific Feature

(summary ~ "authentication" OR description ~ "authentication") AND status != Done

Team's Work This Week

assignee IN membersOf("dev-team") AND updated >= startOfWeek()

Epics Without Stories

type = Epic AND issueFunction NOT IN linkedIssuesOf("type = Story")

Building Complex Queries

Step-by-Step Approach

1. Start with project:

   project = PROJ
   

2. Add status filter:

   project = PROJ AND status IN ("To Do", "In Progress")
   

3. Add assignee:

   project = PROJ AND status IN ("To Do", "In Progress") AND assignee = currentUser()
   

4. Add time filter:

   project = PROJ AND status IN ("To Do", "In Progress") AND assignee = currentUser() AND created >= -30d
   

5. Add sorting:

   project = PROJ AND status IN ("To Do", "In Progress") AND assignee = currentUser() AND created >= -30d ORDER BY priority DESC, updated DESC
   

Optimization Tips

Use Specific Fields

❌ Slow:

text ~ "bug"

summary ~ "bug" OR description ~ "bug"

Limit Date Ranges

❌ Slow:

created <= now()

created >= -90d

Use IN Instead of Multiple OR

❌ Verbose:

status = "To Do" OR status = "In Progress" OR status = "Review"

status IN ("To Do", "In Progress", "Review")

Order Matters for AND

Put most restrictive conditions first:

assignee = currentUser() AND status != Done AND type = Bug

Testing Queries

When I build a query for you, I'll:

1. Explain the logic: Break down what each part does
2. Test it: Use

   /jira-search

   to verify results
3. Refine: Adjust based on results
4. Optimize: Suggest improvements for performance

Common Use Cases

Sprint Planning

project = PROJ AND status = "To Do" AND sprint IS EMPTY ORDER BY priority DESC

Bug Triage

type = Bug AND status = "To Do" AND priority IS EMPTY ORDER BY created DESC

Release Readiness

fixVersion = "v2.0" AND status != Done

Stale Issues

status = "In Progress" AND updated <= -30d

Blocked Work

status = Blocked OR labels = blocked ORDER BY priority DESC

Advanced Patterns

Find Issues Without Estimates

project = PROJ AND "Story Points" IS EMPTY AND type IN (Story, Task)

Parent Issues with Incomplete Subtasks

issueFunction IN parentsOf("status != Done")

Issues Mentioned in Comments

comment ~ "needs review"

Cross-Project Search

project IN (PROJ1, PROJ2, PROJ3) AND assignee = currentUser()

How I'll Help

When you need a JQL query, I will:

1. Understand your requirements: What are you trying to find?
2. Build the query: Construct JQL step-by-step
3. Explain each part: Help you understand the syntax
4. Test it: Run the query using

   /jira-search

5. Refine: Adjust based on results
6. Save for reuse: Document the query for future use

Example Interaction

You: "Find all high-priority bugs assigned to me that were updated in the last week"

Me: "I'll build a JQL query for that:

type = Bug AND priority = High AND assignee = currentUser() AND updated >= -7d ORDER BY updated DESC

Breaking it down:

• type = Bug

  : Only bugs

• priority = High

  : High priority only

• assignee = currentUser()

  : Assigned to you

• updated >= -7d

  : Updated in last 7 days

• ORDER BY updated DESC

  : Newest first

Let me search for these issues using

/jira-search

References

For more JQL details:

• Jira Query Language documentation: https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/
• JQL functions: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/
• JQL operators: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/