Build Useful JQL Filters for Daily Delivery Reviews
Build and validate a focused JQL filter for unfinished work, then use saved searches to support a specific delivery conversation.
Begin with a review question
A useful search answers a question such as “Which unfinished items have gone longest without an update?” Define the project scope and intended action before adding conditions. Jira permissions affect which results a person can see, so an empty search does not necessarily mean no work exists. Confirm access and expected examples before using a filter as evidence in a delivery report.
Try a small query
For a project with the illustrative key DEMO, start with this JQL: project = DEMO AND statusCategory != Done ORDER BY updated ASC. Replace DEMO with your actual key and validate the query in Jira's advanced search. The filter selects work outside the Done status category and sorts by oldest update first. It does not prove those items are blocked or overdue; it identifies candidates for review.
Add conditions one at a time
First verify project scope, then status, then sorting. If you later add an assignee or label condition, test a known matching item and a known nonmatching item. Use parentheses when combining AND and OR so the intended grouping is clear. Keep a brief explanation beside the saved filter. A complicated query nobody can explain is difficult to maintain when workflows or field usage change.
Check what the fields really mean
An updated timestamp can change because of routine edits, so it is not a direct measure of work-item age or meaningful progress. Status categories also depend on workflow configuration. Compare several results with their histories before choosing an escalation. The board mapping guide helps explain why a search and a visual board may present different subsets of the work.
Save a filter with an owner
Name the filter for its purpose, record who maintains it, and review its sharing permissions. When using it in a dashboard, check the view with the intended audience's access. Revisit filters after workflow changes and remove obsolete duplicates through your normal administration process. Pair the search with a backlog review routine so the result leads to decisions rather than another unattended list.
Source reference
JQL syntax reference: Atlassian advanced search documentation.
Published by AgilePro.info under our Editorial Policy. Guidance is based on established delivery practice and is general information, not professional advice for a specific project.