Note that you can only find issues for which you have the “View Voters and Watchers” permission, unless you are searching for your own votes. Search for issues where the time spent is set to a particular jql queries examples value (i.e. a number, not a date or date range). Use “w”, “d”, “h” and “m” to specify weeks, days, hours, or minutes. Some characters and words are reserved and you can’t search for issues using these.

what is jql

To find issues that are running based on calendar hours, use withincalendarhours(). Returns issues that have an SLA that is running, regardless of the calendar. Returns issues whose SLA clock is at a certain point relative to the goal. To find issues that are paused because they are outside calendar hours, use withincalendarhours().

You don’t have to be technical to use JQL

Search for issues that match the selected values of a ‘cascading select’ custom field. Since SELECT and FROM are compulsory, this shows a minimal query. The FROM clause states one or more identification variables or query variables. It is analogous to loop variables present in programming languages. Each identification variable denotes iteration over database objects.

Search for issues that are due by the end of the last day of the current week. By default, this function considers Saturday to be the last day of the week. You can use a different day (for example, Sunday) as the end of the week. Perform searches based on the earliest unreleased version in a project. So if you are creating a saved filter that you expect to be used by anonymous users, do not use this function.

Issue key

Different projects may have versions with the same name. 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.

Now running JQL searches 33% faster than Jira 7.12 and almost entirely eliminating memory issues previously faced when making complex searches. In addition to built-in JQL, the Atlassian Marketplace contains plugins with advanced JQL functionality. The Full-Text Search Attachments for Jira Plugin, for example, enables JQL statements to search attachments for the name, type, and content. You can even build your own plugins with Java, JavaScript, CSS, and HTML skills.