The Complete JQL and Jira Search Course - Go From Zero to Hero

Zenler Player

Your course is loading. Hang tight.

Course Overview & Learning Objectives Preview
Setting Up Your Free Jira Cloud Instance
Generating Realistic Sample Data for Practice

Jira JQL Basics: Basic Search vs. Advanced JQL Search Preview
Mastering JQL Core Syntax & Structure
Fuzzy vs. Exact Text Search in Jira JQL
Logical Operators in Jira JQL - Precision Filtering with AND, OR, and NOT
Filtering Empty Fields in Jira with IS EMPTY and IS NOT EMPTY

Time-Based Queries with startOfDay() and endOfDay() Functions
Dynamic Personal Filters with currentUser() and membersOf()
Querying Sprints: openSprints, closedSprints, and futureSprints
Querying Parent Issues and Hierarchy in Jira
Querying by Component, Fix Version, and Affected Version

Sorting Search Results in Jira JQL
Tracking Issue Status History with WAS and CHANGED Keywords
Advanced Historical Tracking: Filtering with DURING and BEFORE
Finding Unlinked Issues and Issues with No Sub-tasks in Jira

Saving, Managing, and Sharing Jira Filters
Creating a New Blank Dashboard in Jira
Analyzing Metrics with the Two-Dimensional Filter Statistics Gadget
Visualizing Data with Jira Pie Chart Gadgets
Monitoring Sprint Health & Agile Team Performance
Setting Up and Reading the Jira Sprint Burndown Gadget

Creating an Overdue Work Filter for Teams in Jira
Building Automated Rules in Jira Using JQL
Combining JQL and Dashboards for Portfolio-Level Visibility
Sharing Jira Dashboards with External Users & Key Limitations
Step-by-Step: Building a Daily Morning Triage Dashboard

Introduction to Rovo and AI Features in Jira Preview
Generating Complex JQL Queries Using Plain English AI Prompts
Explaining Complex JQL Queries in Plain English via Rovo Chat
Debugging Broken JQL Queries with Rovo AI Error Fixer
Generating AI Summaries for Long Ticket Threads
Automating Backlog Breakdown: Story to Sub-tasks with AI
Generating AI Acceptance Criteria & BDD Content in Seconds
Linking Jira Context to Confluence Knowledge Base using Rovo
AI-Powered Backlog Refinement Engine for Agile Teams

Course Summary & Next Steps

Course Contents and JQL Basics Preview
Quick Search in Jira
Smart Querying in Jira
Smart Query by Project, Overdue and Reporter
Smart Querying by Priority, Resolution and Issue Type
Smart Query by Component
Smart Query with Version and Fix Version
Smart Query Based on Created, Updated and Due
JQL Query Basics
JQL Fields, Operators and Keywords
Understanding JQL Operators
JQL Operators - IN and NOT IN
JQL Operators - CONTAINS and NOT CONTAINS
JQL Operators - IS | IS NOT | WAS | WAS NOT
JQL Operators - WAS IN | WAS NOT IN | CHANGED
Understand JQL Keywords with Examples
JQL Function - cascadeOption
JQL Functions - openSprints | closedSprints | futureSprints
JQL Function - componentsLeadByUser
JQL Functions - currentLogin | lastLogin | currentUser | issueHistory
JQL Functions - releasedVersions | unreleasedVersions | latestReleasedVersion | earliestUnreleasedVersion
JQL Functions - linkedIssue | linkedIssues
JQL Functions - standardIssueTypes | subtaskIssueType | parentEpic
JQL Functions - updatedBy | votedIssues | watchedIssues
JQL Functions - now | startofDay | endOfDay
JQL Functions - startOfWeek | endOfWeek
JQL Functions - startOfMonth | endOfMonth
JQL Functions - startOfYear | endOfYear
JQL Functions - projectsLeadByUser
JQL Functions - projectsWhereUserHasPermission | projectsWhereUserHasRole