Filters and JQL
Jira for Scrum Masters: Filters and JQL
Filters and JQL (Jira Query Language) are powerful Jira features that help Scrum Masters and Agile teams quickly search, organize, analyze, and monitor issues across projects and Sprints.
JQL is to Jira what SQL is to databases—it allows users to find exactly the issues they need using custom queries.
What are Jira Filters?
A Filter is a saved search that displays issues matching specific criteria. Filters can be reused in dashboards, boards, reports, and subscriptions.
Show all open bugs assigned to the QA team.
What is JQL?
Jira Query Language (JQL) is Jira's advanced search language used to search issues based on fields, values, operators, and conditions.
Field → Operator → Value
Why Scrum Masters Use Filters and JQL
| Purpose | Benefit |
|---|---|
| Sprint Monitoring | Track Sprint progress quickly |
| Issue Analysis | Identify blockers and risks |
| Reporting | Create custom dashboards and reports |
| Team Visibility | Focus on relevant work items |
Common JQL Fields
| Field | Description |
|---|---|
| project | Project name or key |
| assignee | Assigned team member |
| status | Issue status |
| priority | Issue priority |
| issuetype | Story, Task, Bug, Epic, etc. |
| sprint | Sprint information |
| labels | Issue tags |
| created | Creation date |
Common JQL Operators
| Operator | Meaning |
|---|---|
| = | Equals |
| != | Not Equals |
| IN | Matches multiple values |
| NOT IN | Excludes values |
| AND | Combines conditions |
| OR | Alternative conditions |
| ORDER BY | Sorts results |
Basic JQL Examples
project = "ECOM"
Show all open issues:
status = "Open"
Show all bugs:
issuetype = Bug
Show issues assigned to a user:
assignee = currentUser()
Sprint-Related JQL Examples
sprint in openSprints()
Completed Sprint Issues:
sprint in closedSprints()
Incomplete Issues in Current Sprint:
sprint in openSprints() AND status != Done
Scrum Master JQL Examples
| Use Case | JQL Query |
|---|---|
| High Priority Issues | priority = High |
| Blocked Issues | status = Blocked |
| Unassigned Work | assignee IS EMPTY |
| Open Bugs | issuetype = Bug AND status != Done |
| Stories in Current Sprint | issuetype = Story AND sprint in openSprints() |
Advanced JQL Examples
issuetype = Bug AND priority = High AND status != Done
Issues Created Last 7 Days:
created >= -7d
Issues Assigned to Current User:
assignee = currentUser()
Stories Sorted by Priority:
issuetype = Story ORDER BY priority DESC
Creating a Saved Filter
- Open Jira Search
- Select Advanced Search
- Enter JQL Query
- Run Search
- Click Save As
- Provide Filter Name
- Share with Team if required
Using Filters in Dashboards
Saved Filters can be used in Dashboard Gadgets such as:
- Filter Results Gadget
- Pie Chart Gadget
- Created vs Resolved Chart
- Two-Dimensional Statistics
- Issue Statistics Gadget
Role of Scrum Master
- Create Sprint monitoring filters
- Track blocked and high-priority issues
- Support reporting and dashboards
- Provide visibility to stakeholders
- Analyze Sprint health using JQL queries
Best Practices
- Use meaningful filter names
- Save frequently used searches
- Keep JQL queries simple when possible
- Share useful filters with the team
- Use filters to drive dashboard reporting
Common Mistakes
- Creating overly complex JQL queries
- Using outdated filters
- Not documenting important filters
- Ignoring query performance
- Creating duplicate filters
Real-World Example
A Scrum Master wants to identify all unfinished work before the Sprint ends.
JQL:
sprint in openSprints() AND status != Done
This instantly displays all incomplete issues that may impact the Sprint Goal.
Example Interview Answer
Filters and JQL in Jira are used to search, organize, and analyze issues efficiently. JQL allows advanced querying of project data, while saved filters can be reused in dashboards, reports, and boards. As a Scrum Master, I use JQL to track Sprint progress, identify blockers, and provide visibility to stakeholders.
Conclusion
Filters and JQL are among the most powerful features in Jira. They enable Scrum Masters to gain deep insights into project data, monitor Sprint health, create meaningful reports, and improve decision-making throughout the Agile lifecycle.