Jira Query Language Cheat Sheet



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)

Turn work across tasks, projects, initiatives into custom reports that can be saved, shared, or added to a dashboard. Advanced search is a powerful tool for getting project data right at your fingertips. Search issues across projects using the Jira Query Language (JQL). JIRA Query Language (JQL) Filtering. Should you require additional filtering over and above the simple column filters provided in the UI, you can access the JQL interface by clicking the 'Advanced' link. This interface accepts query statements written in JQL, which allows you to create powerful cross-sections of data with relative ease. Terms defined in the Cheat Sheet: Agile methodology, Scrum approach to project management, Kanban approach, Sprints, Issues, Tickets, Jira Query Language (JQL) for issue search, Backlog and version search, Burndown reporting tool and charts and dashboard generation functionalities in JIRA tool. This Best Practice includes. JQL - Jira Query Language; JQL Cheat Sheet Diagram; Dashboards. What is Dashboard? Dashboard Best Practices; Anatomy of a Dashboard; How to set up dashboard? Create a Dashboard; Locate and Manage Dashboards; DASHBOARD LAYOUT. What is Gadget; Search and Filters; Boards. Kanban/Scrum Boards. Create a Kanban Board; Configuring Columns; Editing.

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

An introduction to Jira Query Language 6. Using JQL for search 7. Exporting data from jira 4. Jira Dashboards 1. What is a Jira dashboard? How to customize your Jira dashboard 3. How to share your dashboards 5. Getting Started With Jira 1.1 What is Jira? Before we get into the nitty gritty of how to use Jira, I’ll give you a.

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.

  • JIRA Tutorial
  • JIRA Useful Resources
  • Selected Reading

Apart from the type of searches explained in the previous chapter, JIRA also has a few advanced search options, which can be performed using the following three ways.

  • Using Field Reference
  • Using Keyword Reference
  • Using Operators Reference

These above-mentioned three ways have been explained in detail below.

The user should consider the following points while performing any advanced search.

  • Advanced search uses structured queries to search for JIRA issues.

  • Search results displays in the Issue Navigator.

  • Search results can be exported to MS Excel and many other available formats.

  • Save and Subscribe features are available to advanced searches.

  • An advanced search uses the JIRA Query Language known as JQL.

  • A simple query in JQL consists of a field, operator, followed by one or more values or functions. For example, the following simple query will find all issues in the 'WFT' project −

  • JQL supports SQL like syntax such as ORDER BY, GROUP BY, ISNULL() functions, but JQL is not a Database Query Language.

Using Field Reference

A field reference means a word that represents the field name in the JIRA issue including the custom fields. The syntax is −

The operator compares the value of the field with value presents at right side such that only true results are retrieved by query.

  • Go to Issues → Search for Issues in the navigator bar.

The following screenshot shows how to navigate the Search section.

If there is an existing search criterion, click on the New Filter button to reset the criteria. The following screenshot shows how to start with a new criteria −

Query

Type the query using the Field, Operator and Values like issueKey = “WFT-107”.

There are other fields as well – Affected Version, Assignee, Attachments, Category, Comment, Component, Created, Creator, Description, Due, Environment, etc. As soon as the user starts typing, the auto-complete functionality helps to write in the defined format.

Cheat

The following screenshot shows how to add Field Name criteria using advanced features.

Operator selection − The following screenshot shows how to select operators.

The next step is to enter the value and then click on the Search symbol. The following screenshot shows how to add values and search.

The following screenshot shows the search result based on criteria set.

Language

Using Keyword Reference

Here, we will understand how to use a keyword reference and what its advantages are

A keyword in JQL −

  • joins two or more queries together to form a complex JQL query.
  • alters the logic of one or more queries.
  • alters the logic of operators.
  • has an explicit definition in a JQL query.
  • performs a specific function that defines the results of a JQL query.

List of Keywords −

  • AND − ex - status = open AND priority = urgent And assignee = Ashish.
  • OR − ex – duedate < now() or duedate is empty.
  • NOT − ex – not assignee = Ashish .
  • EMPTY − ex - affectedVersion is empty / affectedVersion = empty.
  • NULL − ex – assignee is null.
  • ORDER BY − ex – duedate = empty order by created, priority desc.

Similar to field reference, as soon as the user starts typing, the auto-complete functionality helps to get the correct syntax. The following screenshot shows how to add keywords.

Click on the Search symbol and it will provide the search results. The following screenshot shows the result based on a criteria set.

Using Operators Reference

Jira Query Language Jql

Web scraping amazon python. Operators are used to compare values of the left side with the right side, such that only true results display as the search result.

List of Operators

Jira Query Language Dates

  • Equals: =
  • Not Equals: !=
  • Greater Than: >
  • Less Than: <
  • Greater Than Equals: =>
  • Less than equals: =<
  • IN
  • NOT IN
  • CONTAINS: ~
  • Does Not contain: ! ~
  • IS
  • IS NOT
  • WAS
  • WAS IN
  • WAS NOT IN
  • WAS NOT
  • CHANGED

Jira Query Language Cheat Sheet Free

Similar to the Field and the Keyword Reference, these operators can also be used to enhance the search results.





Comments are closed.