RulesA classic query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions.
Field - Fields are different types of information in the system. fixVersion, issue type, date created, etc.
Operator - Operators are the heart of the query. They relate the field to the value. equals (=), not equals (!=), less than (<), etc.
Function - A function performs a calculation on either specific Jira data or the function's content.
Keyword - Keywords are specific words in the language that have special meaning.
|
FieldsJira Software | Assignee | Attachments | Category | Comment | Component | Component | Created | Creator | Description | Due | Environment | Epic link | Filter | Fix version | Issue key | Issue link type | Labels | Last viewed | Level | Parent | Priority | Project | Reporter | Resolution | Resolved | Sprint | Status | Summary | Text | Type | Updated | Voter | Watcher | | | JSD Specific | Approvals | Customer Request Type | Request channel type | Request last activity time | SLA |
KeywordsAND | Combine multiple clauses | OR | Choice between multiple clauses | NOT | Negate a clause or JQL query | EMPTY , NULL | Field without a value | ORDER BY | Specify the sorting order |
| | Operators= , != | equals, not equals | > , >= | (strictly) greater than | < , <= | (strictly) lesser than | ~ , !~ | contains, do not contain | changed | field value has been changed before | is, is not | field has no value (only with EMPTY or NULL) | was, was not | field has or had the specified value. Only works with Assignee, Fix Version, Priority, Reporter, Resolution and Status fields | was in, was not in | field has or had any of multiple specified values | in, not in | field is one of multiple specified value |
FunctionsUser | Issue | Time | currentUser() | linkedIssues() | now() | membersOf() | latestReleasedVersion() | remaining() | votedIssues() | releasedVersions() | futureSprints() | projectsLeadByUser() | unreleasedVersions() | issueHistory() | componentsLeadByUser() | openSprints() | startOfDay/Week/Month/Year() | updatedBy() | standardIssueTypes() | endOfDay/Week/Month/Year() | watchedIssues() | subtaskIssueTypes() | elapsed() *JSD only | projectsWhereUserHasRole() | completed() *JSD only | paused() *JSD only | pendingBy() *JSD only | myApproval() *JSD only | running() *JSD only | approver() *JSD only | breached() *JSD only | pending() *JSD only |
-
Note: For time range you can either use the standard date format "yyyy-MM-dd", for example updated < "2020/09/16".
Or use "w" (weeks), "d" (days), "h" (hours) or "m" (minutes) to specify a date relative to the current time, for example: updated < "-2w". Advanced searchWildcard searches | Fuzzy searches | To do a single character wildcard search, use the "?" symbol | To do a fuzzy search, use the "~" symbol at the end of a single word term. | To do a multiple character wildcard search, use the "*" symbol. | Proximity searches | Wildcard characters need to be enclosed in quote-marks. E.g. summary ~ "cha?k" | To do a proximity search, use the "~", symbol at the end of a phrase. |
|
Created By
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets