Introduction to JQL: A beginner's guide to more advanced Jira filters

Learning to make filters with JQL will take your Jira Dashboards to the next level. Advanced search isn't difficult when you understand the basic structure of a JQL query: Field, operator, value. You can chain these together with keywords like AND and OR, and group logic with parentheses.

📚 Useful docs on the Atlassian site:
Functions
https://support.atlassian.com/jira-so...

Fields
https://support.atlassian.com/jira-so...

Operators
https://support.atlassian.com/jira-so...

Keywords
https://support.atlassian.com/jira-so...


Chapters
00:07 - The filter view
00:50 - The structure of a basic JQL query
02:17 - What fields can I search for?
06:18 - Add a list of keywords and operators
06:19 - add note that there are more for other usecases
06:48 - IS
07:06 - NOT
07:50 - WAS
08:56 - IN
09:23 - Multi-part JQL queries
09:47 - ~ Contains
10:13 - Parentheses
10:33 - More complex filters - AND
10:55 - OR
12:19 - More complex filters - OR
13:05 - () Grouping queries with parentheses
16:58 - Functions
17:06 - currentUser()
18:42 - Start of day/week/month/year
19:47 - Updated since last login
20:14 - Linked issues
20:42 - Atlassian documentation
21:02 - Watched issues
21:44 - Working with dates and date ranges