-
Jira Query Language (JQL) Essentials & Core Syntax
5 Lessons -
Time-Based & Dynamic JQL Querying
5 Lessons-
StartTime-Based Queries with startOfDay() and endOfDay() Functions
-
StartDynamic Personal Filters with currentUser() and membersOf()
-
StartQuerying Sprints: openSprints, closedSprints, and futureSprints
-
StartQuerying Parent Issues and Hierarchy in Jira
-
StartQuerying by Component, Fix Version, and Affected Version
-
-
Advanced JQL Tracking, Sorting & Unlinked Issues
4 Lessons -
Custom Jira Dashboards, Gadgets & Reporting
6 Lessons-
StartSaving, Managing, and Sharing Jira Filters
-
StartCreating a New Blank Dashboard in Jira
-
StartAnalyzing Metrics with the Two-Dimensional Filter Statistics Gadget
-
StartVisualizing Data with Jira Pie Chart Gadgets
-
StartMonitoring Sprint Health & Agile Team Performance
-
StartSetting Up and Reading the Jira Sprint Burndown Gadget
-
-
Real-World Triage, Automation & Portfolio Dashboards
5 Lessons-
StartCreating an Overdue Work Filter for Teams in Jira
-
StartBuilding Automated Rules in Jira Using JQL
-
StartCombining JQL and Dashboards for Portfolio-Level Visibility
-
StartSharing Jira Dashboards with External Users & Key Limitations
-
StartStep-by-Step: Building a Daily Morning Triage Dashboard
-
-
Jira AI & Atlassian Rovo Features
9 Lessons-
PreviewIntroduction to Rovo and AI Features in Jira
-
StartGenerating Complex JQL Queries Using Plain English AI Prompts
-
StartExplaining Complex JQL Queries in Plain English via Rovo Chat
-
StartDebugging Broken JQL Queries with Rovo AI Error Fixer
-
StartGenerating AI Summaries for Long Ticket Threads
-
StartAutomating Backlog Breakdown: Story to Sub-tasks with AI
-
StartGenerating AI Acceptance Criteria & BDD Content in Seconds
-
StartLinking Jira Context to Confluence Knowledge Base using Rovo
-
StartAI-Powered Backlog Refinement Engine for Agile Teams
-
-
COURSE VIDEOS OF OLD JQL VERSION (ARCHIVED)
30 Lessons-
PreviewCourse Contents and JQL Basics
-
StartQuick Search in Jira
-
StartSmart Querying in Jira
-
StartSmart Query by Project, Overdue and Reporter
-
StartSmart Querying by Priority, Resolution and Issue Type
-
StartSmart Query by Component
-
StartSmart Query with Version and Fix Version
-
StartSmart Query Based on Created, Updated and Due
-
StartJQL Query Basics
-
StartJQL Fields, Operators and Keywords
-
StartUnderstanding JQL Operators
-
StartJQL Operators - IN and NOT IN
-
StartJQL Operators - CONTAINS and NOT CONTAINS
-
StartJQL Operators - IS | IS NOT | WAS | WAS NOT
-
StartJQL Operators - WAS IN | WAS NOT IN | CHANGED
-
StartUnderstand JQL Keywords with Examples
-
StartJQL Function - cascadeOption
-
StartJQL Functions - openSprints | closedSprints | futureSprints
-
StartJQL Function - componentsLeadByUser
-
StartJQL Functions - currentLogin | lastLogin | currentUser | issueHistory
-
StartJQL Functions - releasedVersions | unreleasedVersions | latestReleasedVersion | earliestUnreleasedVersion
-
StartJQL Functions - linkedIssue | linkedIssues
-
StartJQL Functions - standardIssueTypes | subtaskIssueType | parentEpic
-
StartJQL Functions - updatedBy | votedIssues | watchedIssues
-
StartJQL Functions - now | startofDay | endOfDay
-
StartJQL Functions - startOfWeek | endOfWeek
-
StartJQL Functions - startOfMonth | endOfMonth
-
StartJQL Functions - startOfYear | endOfYear
-
StartJQL Functions - projectsLeadByUser
-
StartJQL Functions - projectsWhereUserHasPermission | projectsWhereUserHasRole
-
The Complete JQL and Jira Search Course - Go From Zero to Hero
Become an expert in Jira Query Language (JQL), Jira Search and Master the Advanced Jira Search
Course Summary
Learn how to use Jira Query Language (JQL) to write complex and advanced search queries in Jira and pull proper reports for your Jira Dashboards. This course is a comprehensive course which covers all the required details about Jira JQL and Jira Search. We will be learning JQL & Jira Search from scratch and progress to advanced topics of JQL. We will also learn how to write complex queries using JQL.
The course is suitable for anyone who is using Jira in their projects and want's to master JQL and become an expert in Jira Search & Jira Queries.
Course Curriculum
