Advanced searching operators reference Jira Software Data Center and Server 8 18 Atlassian Documentation

Move an issue from To do to In progress to Done without leaving your timeline view. That’s right — Advanced Roadmaps now lets you update your issue’s status directly from your timeline. Use full screen mode to see more issues and enter a more focused view of the board and backlog.

jql documentation

If the
value of any argument to a functional expression
is null or unknown, the value of the functional expression is unknown. A null comparison expression tests whether or not the single-valued path
expression or input parameter is a NULL value. Entities are designated in query strings by their entity

2.5. JPQL Conditional Expressions

You can also search on the released versions of all projects, by omitting the project parameter. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields. In a clause, a function is preceded by an operator, which in turn is preceded by a field. To run a filter, such as New_issues, select the filter name. The JQL for the advanced search will be set, and the search results will be displayed.

  • The FROM clause can contain
    multiple identification variable declarations separated by a comma (,).
  • For a complete reference, check out our help docs on advanced searching.
  • You can optionally specify a user, or if the user is omitted, the current user (i.e. you) will be used.
  • This is due to the fact that the search query is executed over each field in turn, and the result set for each field is combined to form the final result set.
  • JIRA also has a project field that matches the issue key.

Returns issues that whose most recent SLA has missed its goal. When you only use the OR keyword, all clauses will be treated as separate, and equal in terms of precedence. Using “WAS NOT IN” is equivalent to using multiple WAS_NOT statements, but is shorter and more convenient. That is, typing status WAS NOT IN (“Resolved”,”In Progress”) is the same as typing status WAS NOT “Resolved” AND status WAS NOT “In Progress”.


Search for all requests sent by the members of an organization. Returns requests that the members have shared with or kept private from that organization, and with any other organizations they’re a member of. Returns issues that have an SLA that has completed at least one cycle.

jql documentation

Learn more about this issue and how to resolve it in our knowledge base article. Note, this function is only available if you are logged in to Jira. Perform searches based on the latest released version (i.e. the most recent version that has been released) of a specified project. Note, the “latest” is determined by the ordering assigned to the versions, not by actual Version Due Dates.

We’ll be introducing new activities in the future to give you even more visibility over your data security policies. Enjoy stronger brand recognition for your help center, boost credibility and search engine optimization, and offer a customized experience to your help seekers. This greater discoverability will help your customers get to the right place and get the assistance they need. We’re giving you more flexibility to manage user accounts for your domains. You’ll be able to control how and what specific user accounts you’d like to manage.

jql documentation

The docs page has a lot of content, so it’s helpful to do a “Ctrl/Cmd + F” so you can jump directly to a specific topic or keyword of interest. To search for issues that belong to a particular jql queries epic in team-managed projects, use parent. It is possible for your Jira administrator to change the name of a type, which could break any saved filter that rely on that name.

jql documentation

Formerly “Bulk Archive”, selecting pages in the content manager now prompts admins with the option to archive or delete them. Up to 500 pages can be archived at a time, storing them in the archive for future reference. Up to 100 pages can be deleted at a time, moving them to the trash.

Leave a reply

Your email address will not be published. Required fields are marked *