You can search by project name, by project key or by project ID (i.e. the number that Jira automatically allocates to a project). Search for all subtasks of a particular issue in company-managed projects or subtasks of a particular epic in team-managed projects. You can search by issue key or by issue ID (i.e. the number that Jira automatically allocates to an Issue).

These queries are similar in nature, even though they operate on different platforms. Jira Query Language enables anyone to build queries that can be executed in Jira to produce a set of results. These queries are very similar to SQL, GraphQL, and other query languages that enable easy access to large databases or data sets. The function always returns a list of QueryLiteral objects. It is even valid for a scalar function (that is,
a function whose JqlFunction.isList method returns false) to return multiple QueryLiteral objects.

JQL search in Jira Service Management

Find issues in components that are led by a specific user. You can optionally specify a user, or if the user is omitted, jql queries examples the current user (i.e. you) will be used. It uses the “project” field, the EQUALS operator, and the value “TEST”.

what is jql

For the permission parameter, you can specify any of the permissions described on permissions for company-managed projects. Search for issues and sub-tasks that are linked to an epic. It is possible for an issue to belong to both a completed sprint(s) and an incomplete sprint(s).


Jira will first order the list by priority and then sort by assignee for all of the issues with the same priority. Let’s look at another example examining the incoming bugs to our project. We want to see any new critical or blocking bugs that have come in recently to see if recent checkins have decreased stability.

Development managers often have to find areas of risk in their programs. Good queries often take a bit of refinement as they get developed. Let’s see if we can find some risky areas in our project PWC. The “in” keyword will include any item that matches any criteria in the list. In the above example it will return all of the blocker and critical bugs in projects A, B, and C. This is extremely helpful for organizations that have service level agreements (SLA) with their customer base.

Use advanced search with Jira Query Language (JQL)

Then you probably will have stumbled upon the search function in Jira. Be it while looking for a specific ticket, to automate workflows or to create reports. The developers among you might have had a look at the advanced search in Jira as well.

  • We use the DESC keyword to sort in reverse (newest to oldest) so we focus our attention on the most important issues first.
  • This result is better, but now I’m curious to know what didn’t make last sprint and got moved into this sprint.
  • It has insights that beginners need to know on how to use Jira for project management & activity tracking.
  • In the fast-paced world of project management, staying organized and effectively tracking tasks and projects is crucial for success.

You can search by status name or status ID (i.e. the number that Jira automatically allocates to a status). Search for issues that are assigned to a particular sprint. The search is based on either the sprint name or the sprint ID (i.e. the number that Jira automatically allocates to a sprint). You can search by resolution name or resolution  ID (i.e. the number that Jira automatically allocates to a resolution). Search for requests by the channel that they were created by. For example, you could search for all requests that were emailed to the service project, or all requests that were sent from a customer portal.

Component IDs, however, are unique and cannot be changed. Search for issues that are assigned to a particular affects version(s). You can search by version name or version ID (i.e. the number that Jira automatically allocates to a version).

what is jql

If more users are added to the test-engineering group, this query will dynamically update. Using search in Jira Software can help you gain key project insights and answer questions that are relevant to the team. The three flavors of search in Jira software — quick, basic, and advanced — can help you find important information about your projects. Search for new issues created since the start of the first day of the current week.