Atlassian Jql Cheat Sheet

NOT Negate a clause or JQL query EMPTY, NULL Field without a value ORDER BY Specify the sorting order Official cheat sheet A better version of our cheat sheet is available here: https: //b it.l y/ 3rFJxTl Operators =,!= equals, not equals , = (strictly) greater than. Search issues across all projects using the Jira Query Language (JQL). Query results can be saved and used as filters and views across Jira (including boards). In the top navigation bar, select Filters. Select Advanced issue search. (shortcut g + i) 3. Use quick filters for basic search or switch to JQL for advanced search. Atlassian Jira is a propriety issue tracking software developed by Atlassian which provided provides bug tracking, issue tracking, and project management functions. In this post we will focus on important REST API and JQL(Jira Query Language) provided by Jira. These REST API are popular API which helps to find metadata relate to Jira Project. Notation Comment #anchor ^attachment.ext Creates an internal hyperlink to the specified anchor or attachment. Appending the '#' sign followed by an anchor name will lead into a specific bookmarked point of the desired page.

There are a few JQL syntax bits to get you started:

• AND --- allows you to add qualifiers to a list
• != Thing --- target one thing
• is in (List, Of, Things) --- target a bunch of things (Done, Closed, Resolved) typically
• not in (List, of, Things) --- do not include a bunch of things
• -1w --- relative time. You can also use -1d for day
• '2015/3/15' --- specific dates

JQL Basic Filters

Here are a few of the basic filters I could not live without.

Specific sprint (type slowly and JIRA will suggest sprint numbers)

Closed this Week (awesome for weekly reports! put this on your dashboard!)

Want to download and sort your backlog in a spreadsheet? Here’s your JQL!

Open Epics

Issues tagged XXX (in this case, “easywin”). I made one of these filters for each of my controlled vocabulary.

Open + Backlog (I use this as the starting point for my work / plan board -- you need to include the Epics so that they show up on the left column on the “plan” view. It took me a while to figure that out. The default that comes with your board includes closed issues. WHY?! THEY’RE CLOSED!)

Open Tickets Without Epics

JQL Advanced Filters

You can do fancy shit too.

Tickets created during the pilot window which have been closed which did not get dev attention (Duplicate, Won't Fix, Incomplete definition).

All new tickets opened during the pilot window (includes duplicates, and incomplete tickets reported through the JIRA public feedback form).

Tickets which were closed during the pilot window (regardless of when they were created).

Tickets that were opened during the a specific window AND resolved during this time.

Want to quickly see the Jira issues that were completed yesterday by your team, yourself or the whole company? JQL lets you do this (and a whole lot more) with ease.

Lets start with the simplest possible query. We can then add conditions one at a time and examine what each does. In the end, you will have a powerful query that can be easily customized to your projects.

This example assumes issues are considered complete when marked as either ‘Resolved’ or ‘Done. This could be different from your projects. To use this query simply replace the statuses with the ones that make sense for your projects.

The first thing you will probably want to improve is limiting your search to specific projects. We can do that by scoping the query to a project called ‘TEST’

Jira Jql Commands Cheatsheet

If the issue was marked as completed yesterday but was then subsequently moved to a new status it will still be returned by this query. We should fix that by adding a condition to check the current status of the issues.

Atlassian Jql Cheat Sheet 2019

The last thing to do is limiting our search to issues resolved by a specific member of your team. To do this, lets add some additional JQL. The ‘by’ operator signifies the person that made the change, and we then pass in a Jira username.

Awesome! We now have a powerful query to find Jira issues completed yesterday. You can use this to quickly display issues in Jira, set up a reusable filter, run directly from Slack or receive a custom daily Slack message from stratejos.

Supercharging JQL with stratejos

stratejos lets you get more out of the tools you use with your team every day. Think of stratejos as a smart extra set of hands that frees you up to focus on the things that matter to your customers.

stratejos give you two powerful ways to supercharge your use of JQL.

Run JQL commands from Slack

Atlassian Jql Cheat Sheets

Atlassian Jql Cheat Sheet Excel

Get custom Jira messages in Slack

Further reading

Want to dive deeper into JQL? Check out these great resources from around the interwebs.