Jira Snippet Library: JQL - Jira Service Management Examples

[#1]

Here are some helpful queries, formats, and functions to use in Jira Service Management (JSM).

Approvals

There are many helpful JQL functions for querying approval data. A function allows the use of variables in a JQL query. The function substitutes the applicable values at the time the query is run. This avoids the need to hard code static data. E.g. Use a query with a function like assignee = currentUser() instead of the less flexible assignee = “Rachel Wright”.

Common Functions

• approved()

• approver()

• myApproval()

• myPending()

• myPendingApproval()

• pending()

• pendingBy()

Examples

• Find items awaiting approval from a specific user

  • approvals = approver(username)

• Find items pending approval

  • approvals = pending()

Requests

Requests are how Jira items are represented, in the self-service portal, to customers or end users. A request is a simplified view of item data.

Tip: Don’t forget to enclose any multi-word work type or request type names in quotes.

• Find incidents

  • type = "[System] Incident"

• Find incidents for a system problem

  • type = "[System] Incident" and "Request Type" = "Report a system problem (project-key)"

• Find items without a request type

  • "Request Type" is empty

Organizations

Organizations are used to group customers together and determine which requests they can view in the customer portal. You can query by organization membership and name.

Tip: Don’t forget to enclose any multi-word organization names in quotes.

• Find requests from one or more specific organizations

  • reporter in organizationMembers(organization-name)

  • organizations = organization-name

  • organizations in (organization1, organization2) 

Service Level Agreements

SLAs represent a goal or a commitment between a service provider and a customer. For example, a high priority request might have a completion goal of one hour. A low priority request might have a first response goal of four hours. There are many helpful JQL functions for querying SLA data.

Common Functions

• breached()

• completed()

• elapsed()

• everBreached()

• paused()

• remaining()

• running()

• withinCalendarHours()

Examples

• Find items where an SLA was not met

  • SLA-name = breached()

• Find items awaiting a resolution for more than 8 hours

  • “Time to Resolution" > elapsed("8h")

Resources

See the Jira Service Management JQL documentation for additional functions, fields, operators, and clauses.

---

Back to intro or article list

[Peter_DevSamurai]

Thank you @Rachel Wright ! Although I don’t use JQL on a daily basis, knowing these is very helpful when I need to find a specific work item. Happy New Year!!!