Search for issues that have builds that have passed or failed on linked Bamboo instances. If you’ve linked your development tools to Jira, you can use even more parameters when performing a search. Adding development information to your JQL queries gives you more visibility of your development tools in Jira.

If an agent starts work at 3pm, they probably want to work on issues from the 9am-5pm agreement first. They can use withincalendarhours() to find all the issues where Time to First Response is running at 3pm. See also startOfWeek(), startOfMonth(), startOfYear(), endOfDay(), endOfWeek(), endOfMonth(), and endOfYear(). Search for issues that require approval or have required approval by the current user.

LESS THAN EQUALS:

For example, you can run this command in the terminal on the Macintosh or Linux workstation. JIRA has a stable REST API to access issues that lets you use the same JQL you do in the UI. The REST endpoint for search returns structured JSON data that’s easy to process and manipulate. Note, this function is only available if you are logged in to Jira. Search for issues that require approval by one or more of the listed users. Returns issues whose SLAs are out of date because someone has changed the SLA in the settings.

Also, the NOT IN operator won’t match a field that has no value (a field is empty). For example, assignee not in (jack,jill) will only match issues that have an assignee and this assignee isn’t “jack” or “jill”. The query controls for priority and limiting the created time properly scopes the query.

Basic and Advanced Searches

For example, the ScriptRunner for JIRA app extends JQL with such functions as myProjects() and projectmatch(). You can also share your queries and filters with other team members. Sharing filters allows others to use the same set of criteria to view issues. Moreover, Jira filters can be embedded into Confluence pages, making it easy to share the insights from your JQL queries with your entire organization. Efficient as it may be, Jira has its limitations when it comes to some search queries. If you want to use the wildcard search not only for text fields but also for dropdown fields or label fields, then our PowerJQL plug-in is just for you.

The IN and NOT IN operators allow using up to 3000 operands. Watch the blogs in this space to get notified when new tips articles like this are posted. And if that’s still not enough, sign up for JIRA Insiders – our monthly newsletter covering all things JIRA. Now let’s see which issues got fixed in the last release. To find issues that are running based on calendar hours, use withincalendarhours().

JQL operators

Note that this query will also return issues with merged pull requests. When using development fields for advanced search, you may see an error stating that the field doesn’t exist or you don’t have permission to view it. Learn more about this issue and how to resolve it in our knowledge base article.

That is, it is used to search for issues where the specified field has no value. Search for issues that have builds on linked Bamboo instances. Now, check the following development fields that can be used in JQL queries.

The basics of JQL Syntax

After the site reindexes and recalculates the SLAs, the function shouldn’t return any issues. Use this function if a reindex is taking a long time or if you’ve deferred the reindex because you’re making a lot of changes. If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfYear(“+1”) is the same as endOfYear(“+1y”). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfWeek(“+1”) is the same as endOfWeek(“+1w”). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfMonth(“+1”) is the same as endOfMonth(“+1M”). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfDay(“+1”) is the same as endOfDay(“+1d”).

• If you want to use the wildcard search not only for text fields but also for dropdown fields or label fields, then our PowerJQL plug-in is just for you.
• The next unit compares the resolution field with the values ​​”Done” and “Unresolved”.
• Perform searches based on the start of the current month.
• If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfMonth(“+1”) is the same as endOfMonth(“+1M”).
• If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfMonth(“+1”) is the same as startOfMonth(“+1M”).

JIRA gives suggestions at each step of the way for each of the three components of our query. When you see the value you’d like to select, you can use the arrow keys or mouse to select it. Using an AND would give only the area covered by both circles, but an OR returns all items in either circle. Generally speaking, AND will narrow your query and jql query return fewer results, while using an OR broadens it and will return more results. The query states that the company must be Acme, the item must be a cookie, and the quantity needs to be three. Since we want items that meet all three criteria, we use the keyword “AND”, which means that the conditions to the left and right of AND have to be met.

Additional JQLs with Atlassian Marketplace apps

Where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfWeek(“+1”) is the same as startOfWeek(“+1w”). If the plus/minus (+/-) sign is omitted, plus is assumed. If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfMonth(“+1”) is the same as startOfMonth(“+1M”). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfDay(“+1”) is the same as startOfDay(“+1d”). Perform searches based on the released versions (i.e. versions that your Jira administrator has released) of a specified project.

Find issues that you have recently viewed, i.e. issues that are in the Recent Issues section of the Issues dropdown menu. See also endOfWeek(), endOfMonth(), and endOfYear(), startOfDay(), startOfWeek(), startOfMonth(), and startOfYear(). If you are creating a saved filter that you expect to be used by anonymous users, don’t use this function.

For detailed description   and examples of their usage for advance searching, check the links from the Reference column. The IN operator is used to search for issues where the value of a specified field is one of multiple specified values. The values are specified as a comma-separated list, surrounded by parentheses. In all the queries we’ve discussed so far, the data is reflective of the current time the query was run. But values for fields like assignee, priority, fix version, and status often change over the course of an issue’s lifecycle. JIRA stores each update an issue goes through, known as an issue’s change history.