Useful JQL tips

This page lists useful JIRA JQL queries that I gathered during my day to day use in JIRA, and managing an operations team.

Tasks that are parents

This requires Script Runner plugin installed

issueFunction in parentsOf("status = Open")

Will filter the tasks that are parents of any subtask that it’s status is open.

Filter Subtasks

This requires Script Runner plugin installed

issueFunction in subtasksOf("status = Open")

Will filter the subtasks of any parent task that it’s status is open.

issueFunction in subtasksOf("status = Open") AND assignee = john.doe

Will filter the subtasks that are assigned to user john.doe and their parent task status status is open.

Task that their status changed last week

Useful to see what has been done last week:

status changed AFTER startOfWeek(-1) BEFORE startOfWeek()

Tasks that their status changed to closed

status changed to Closed

Tasks that changed their status from Open to In Progress

status changed from Open to "In Progress"

Aggregate values

This requires Script Runner plugin installed.

Script Runner supports the following aggregation functions:

• sum() – sum of the field. Supports integers and estimation fields.
• average() – average value of the field
• count() – number of issues returned by the filter
• countBy() – breakdown count of issues (for example by reporter)

project = LOAD and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()")

Will display the total of estimate field for all issues.

project = LOAD and issueFunction in
    aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")

Will display the totals of estimate field for all issues, and the total of remaining work field.

Warning: this is experimental feature as of Script Runner.