The Only JQL Book You Will Ever Need
To Pass Any Atlassian Jira Exam
Get 100 carefully selected JQL queries with examples
and save yourself tens of hours
searching through Atlassian documentation and Internet
Can you learn JQL from the Atlassian documentation?
Hi, I'm Bogdan Gorka, Atlassian Expert
I passed 4 Atlassian Jira ACP Exams (ACP-100, ACP-600, ACP-120, ACP-620).
Each of them had a few not-so-simple JQL related questions. Even if you already have many years of experience, you do not use all types of JQL queries every day. Me neither.
Some JQL queries, which you will see on the Jira exam, may be a big surprise to you. The ACP Exam questions are written to trick you into wrong answers.
That approach applies also to JQL related questions. What is more, I bet you have never seen some types of queries which are tested on the ACP exam.
To prepare for the ACP exam, you should review the Atlassian documentation. Yes, I agree.
But do you really want to learn JQL by going through the Atlassian Documentation or the Atlassian Community?
You will find there only simple examples which will not be very useful for the ACP exam. Searching for valuable examples will take you a lot of time - the time you need to prepare for other topics in your ACP exam preparations.
Accelarate your study with less effort, learn from 100 examples and save many hours of JQL research.
Do you need JQL at all?
The answer to this question is obvious - YES!
Of course you need to know JQL, especially if you plan on becoming a full-time Jira Administrator but also regular Jira users will greatly benefit from this skill. It is not a very complex subject, to be honest. It only requires some practice.
But, it is hard and time consuming trying to understand JQL by memorizing all the types of possible fields, operators and values just from the Atlassian documentation.
It is much more practical to use examples, experiment with them and build up your own queries yourself.
In this book you will find 100 examples to learn from and to build up your own queries.
“I could be doing meaningful, impactful and rewarding work,
but instead I am trying to understand JQL.”
Jira Administrator's troubles with JQL
Save time on your ACP preparations
You should not underestimate JQL ACP questions, because you use JQL in you work every day.
Preparing for the ACP exam, will need from you a lot of preparation and time. On the exam day, there will only be a few JQL related questions but they can be hard to answer. It is better for you not to loose valuable points on wrong answers in JQL related questions.
It is smart to learn the needed material for the JQL topic spending as little time as possible and focus on other, more complex topics. You can save time, when you use the compact content of this book and learn from examples to get well prepared for the ACP exam. You will save time for other exam areas.
“10 to 15% of the ACP-120 Jira Administrator for Cloud Exam total score is tested on how to:
1) translate business requirements into appropriate JQL queries
2) manage shared filters and dashboards and identify the outcome of filter subscription configurations”
ACP-120 Jira Administrator for Cloud Exam Requirements
as Jira user or
as Jira Administrator
How many times have you searched for a JQL example in the Atlassian documentation or somewhere else on the Internet?
I have done it hundreds of times. These minutes add up to hours and hours to days and weeks of wasted time. But now I do not have to do it any more.
Some time ago I created a compact list of the most frequently used JQL queries for my internal use. This saves me precious time when I need to look up a good example which I can extend or merge with another JQL query that I already have.
You can do so too. To save your time, you can use a table added to this book. This table will help you find a specific keyword or operator and grab a good example which you can adapt to your needs
“ACP-620 Managing Jira Cloud Projects Exam Requirements - 15 to 20% of the Exam score
1) Translate business requirements into appropriate JQL queries”
ACP-620 Managing Jira Cloud Projects Exam Requirements
Start learning from examples
This book is all about examples and includes a section for beginners too. If you are only starting your adventure with the JQL, you will learn the basics a lot faster using real-world examples with explanations.
This book will serve you well as reference also later, as it contains easy to find recipes once you know what you are looking for. Also, recipes can be combined with each other.
Price: 12,50 EUR
What will you get in the book
65 Pages of pure content
Short introduction for JQL beginners
For all Jira users who need a refresher before diving in the advanced JQL, I explain the basics in a simple non-technical languange.
JQL recepies with Quick Reference Sheet
In this chapter you get 100 JQL (mainly) advanced query examples with explanations. The JQL collection follows a different grouping logic and queries are combined by fields, by people, by dates and by text.
Jira ACP Exam Practive Questions
For those who are near the ACP exam, you can test your skills with my carefully crafted ACP questions and see how many of them you will solve correctly.
What will you NOT get in the book
- 1JQL relating to Agile
I decided not to include Agile related fields (such as Version or Sprint) because they have never appeared on any of my ACP Jira tests. Also I do not use them very often in my work. There are only a few fields relating to Agile and, in my opinion, reviewing them in the Atlassian documentation should be sufficient for your work and the ACP Exam.
- 2JQL relating to Jira Service Management
This is a very special area of JQL and one needs to understand the service management process basics before learning JQL (they may be tested on Jira Service Management exam ACP-420).
- 3JQL from Jira Add-ons
Many add-ons, especially ScriptRunner, have their own JQL functions. They are very useful but I did not include them because they are not tested on any of ACP exams.
What value will you get?
Here is what beginner users will get with the book
- for the JQL Starters - less advanced JQL recipes with detailed explanations
- every query can be tested in your instance (subject to data availability for date related queries)
- Jira Server and Jira Cloud differences explained
Here is what advanced users will get with the book
- Advanced JQL recipes with detailed explanations.
This is my own collection and something you will not get in this form in any Atlassian documentation
- Effective accelerator to your study if you are preparing of one of Jira ACP exams (ACP-120, ACP-620, ACP-610, ACP-100, ASB-104). Spend time on other more advanced topics and learn all the ACP needed JQL tricks in a few hours.
- JQL Quick Reference Sheet
Do not put the book away after you have reviewed it. This book is not for reading but for using. Once you learn how to use the queries without explanations, use the Quick Reference Sheet which you can print and keep on your desk.
- 10 original questions, which simulate those from the Jira ACP exams - test yourself with the most common tricky questions
for long-term use: 100 queries on 3 pages - quick reference printable sheets which you can print and keep on your desk to save time.
In this section I added 10 ACP simulated questions using the JQL queries from the book. In this way you may test yourself before your real exam. They will be a good test before any Jira ACP exam or a good preparation for the ASB-410 Pro Skill Badge (JQL in Jira Service Management)
About Bogdan Gorka
In my work as Atlassian Expert and Solution Architect I need to know quite a lot about using Jira functionalities.
Writing complex JQL queries belongs to my daily routine. But I cannot keep every little detail in my head so making notes and managing knowledge is a very important aspect of my work.
That is why I use various tools that accelarate my work and help me in learning new things. Based on this need, the content for this book got created - from my notes that I collected and organised over a few years.
I am confident that if this collection is practical for me so it can also be practical for you and other Jira Administrators.
What book reviewers were saying
I liked the book. Definitely the section about working with dates will be useful because it's hard to find something noteworthy which explains this topic the way you do in your book. The rest was familiar to me, but it will definitely be useful for people who are starting their adventure with JQL.
I must congratulate you on the book.
It’s excellent and well written. I have made a start on my review. I will give up a bit of time daily to do the review, which I’m absolutely enjoying.
Reviewing the book was a pleasure. There were a few things I did not know about. I am looking forward to publishing your book. Let me know when the book is ready for purchase.
Junior Jira Administrator
Money Back Guarantee
If you don’t like the JQL Cookbook for any reason, if you feel it wasn’t worth your investment or even if you just want your money back for no reason at all — you do not have to worry. Purchase today and you can simply ask for a refund anytime within the next 14 calendar days. I will then process your refund within 14 calendar days, no questions asked.
Learn JQL today and save your time!
For only 10,00 EUR
Questions relating to purchase
Make the first step today
This collection of 100 JQL queries is a result of a few years of collecting examples during my work as Jira Consultant and during my preparations for Atlassian ACP exams.
I believe that all Readers who buy this book will find it practical in their daily work. More than 90% of JQL queries are prepared in Advanced Mode. It will be so much easier for you to use Jira if you have a ready-to-use collection of queries which you can combine and modify without the need to look for another Jira Community article. And if you expand this collection yourself, this will be the best investment of your money and time for the future.
Price: 10,00 EUR