Jira Advanced Search, JQL & AI: Dashboards & Rovo AI | RCV Academy
Course · Jira & Agile

Write JQL from the basics to historical queries, build dashboards with gadgets your team can use every day, and use Atlassian Rovo AI to generate, explain and fix JQL.

Or get it with every other course: $5.99/month or $99 lifetime · Compare plans
68 lessons in 9 sections4 free preview lessonsCertificate of completion
Jira JQL · Dashboards · Rovo AI Write powerful JQL and build dashboards your team uses daily
  • 68 lessons
  • 4 free previews
Watch free preview lessons
68lessons
9sections
1archived section from the earlier version
4free previews

What you'll learn

Every lesson is recorded in Jira Cloud with realistic sample data.

JQL essentials

Basic vs advanced search, core syntax, fuzzy vs exact text search, AND, OR and NOT, and IS EMPTY checks.

Time-based and dynamic queries

startOfDay() and endOfDay(), currentUser() and membersOf(), sprint functions, parent hierarchy, components and versions.

Advanced tracking

Sorting results, status history with WAS and CHANGED, DURING and BEFORE, and finding unlinked issues and issues with no sub-tasks.

Dashboards and gadgets

Share filters, build dashboards, and use Two-Dimensional Filter Statistics, pie charts and the Sprint Burndown gadget.

Triage and automation

Overdue work filters, automation rules using JQL, portfolio-level dashboards, sharing with external users, and a daily triage dashboard.

Rovo AI for JQL

Generate JQL from plain English, explain and debug queries, summarise long threads, and generate acceptance criteria and BDD content.

From query to dashboard

The course follows the path a real report takes.

1

Write the query

Build precise JQL with operators, functions and history keywords.

2

Save the filter

Save, manage and share filters with your team.

3

Build the dashboard

Turn filters into gadgets and dashboards.

4

Speed it up with AI

Use Rovo to generate, explain and fix JQL.

Course curriculum

9 sections68 lessons0 downloadable practice files4 free previews
1Introduction & Getting Started3 lessons+
  • Course Overview & Learning ObjectivesFree preview
  • Setting Up Your Free Jira Cloud Instance
  • Generating Realistic Sample Data for Practice
2Jira Query Language (JQL) Essentials & Core Syntax5 lessons+
  • Jira JQL Basics: Basic Search vs. Advanced JQL SearchFree 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
3Time-Based & Dynamic JQL Querying5 lessons+
  • 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
4Advanced JQL Tracking, Sorting & Unlinked Issues4 lessons+
  • 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
5Custom Jira Dashboards, Gadgets & Reporting6 lessons+
  • 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
6Real-World Triage, Automation & Portfolio Dashboards5 lessons+
  • 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
7Jira AI & Atlassian Rovo Features9 lessons+
  • Introduction to Rovo and AI Features in JiraFree 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
8Course Conclusion1 lesson+
  • Course Summary & Next Steps
9COURSE VIDEOS OF OLD JQL VERSION (ARCHIVED)30 lessons+
  • Course Contents and JQL BasicsFree 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

Lessons marked Free preview open without enrolling. Enroll for $29.99 →

Who this course is for

Jira users who only use basic search

Learn JQL so you can ask Jira precise questions.

Scrum Masters and project managers

Build sprint health and portfolio dashboards for stakeholders.

QA engineers and test leads

Track defects, overdue work and status history with JQL.

Jira administrators

Use JQL in automation rules and shared filters.

What you need

  • A free Jira Cloud site, which you set up in the first section.
  • Basic familiarity with Jira issues helps.

Meet your instructor

Manish Verma, instructor

Manish Verma

Founder, Software Testing Mentor & RCV Academy
20+ years in QA52,000+ students235,000+ YouTube subscribers

20+ years in QA and test automation at organisations including IBM, Infosys, Capgemini, National Australia Bank, Westpac, ANZ and Coles. Most recently a Senior QA Automation Engineer and Framework Architect, leading a migration to a modern Playwright framework in JavaScript/TypeScript.

He holds Atlassian Jira Administration expertise, including Xray, Zephyr, JQL and Jira Automation, and has taught 52,000+ students.

Choose how you want to learn

Buy this course on its own, or get it with every other RCV Academy course.

This course only

One-time

$29.99
one-time payment · 30-day money-back guarantee
  • Lifetime access to this course
  • Certificate of completion
Buy this course
All courses

Monthly

$5.99
per month · cancel anytime · 7-day full refund
  • This course and all other published courses
  • Certificates of completion
  • Access while your membership is active
Start monthly
Best value
All courses, forever

Lifetime

$99
one-time · 30-day money-back guarantee
  • This course and all current courses
  • Every future course included
  • Certificates and lifetime updates
Get lifetime access

Try it risk-free

This course and the Lifetime plan come with a 30-day money-back guarantee. The Monthly plan has a full refund within the first 7 days.

Questions

Frequently asked questions

Do I need a paid Jira subscription?+
No. The course shows you how to sign up for a free Jira Cloud site to practise in.
Do I need Atlassian Rovo?+
Rovo is needed only for the Rovo AI section. The JQL and dashboard sections work in any Jira Cloud site.
What is the archived section?+
The last section keeps the videos from the earlier version of this course (JQL operators, keywords and functions). They are recorded in an older Jira interface; the main sections cover the current Jira Cloud interface.
Can I watch some lessons before buying?+
Yes. Several lessons are free previews, including Basic Search vs Advanced JQL Search and Introduction to Rovo and AI Features in Jira.
What is the difference between the plans?+
One-time gives you lifetime access to this course. Monthly ($5.99) gives you this course and every other published course while your membership is active. Lifetime ($99) gives you every current and future course, permanently.
What should I take next?+
Enroll for $29.99
Lifetime access to this course · 30-day money-back guarantee
$29.99One-time · lifetime access
Enroll now

Course Curriculum