等于: = "= " 运算符用于查找精确匹配字段值的问题。 (注意: 不能用于 文本 字段; 文本字段的匹配条件请使用 包含 运算符。) 要精确匹配多个字段值,请使用与(AND)将多个 "= " 表达式连接起来。 示例 - 查找由jsmith创建的所有问题:
- 查找由John Smith创建的所有问题:
代码块 |
---|
reporter = "John Smith" |
不等于: != "!= " 运算符用于查找不等于指定字段值之外的问题。 (注意: 不能用于 文本 字段; 文本字段的否定条件请使用 不包含 ("!~ ") 运算符。) 注意输入 field != value 与输入 NOT field = value}}具有同等效果, 并且 {{field != EMPTY 与 {{field #IS_NOT EMPTY}}也具有同等效果。 示例 - 查找所有已经被分配经办人,但是经办人不是jsmith的问题: or:
- 查找报告人不是jsmith的所有问题:
- 查找你报告的,但经办人没有被分配给你的问题:
代码块 |
---|
reporter = currentUser() and assignee != currentUser() |
- 查找已经被分配经办人,但报告人或经办人不是John Smith的问题:
代码块 |
---|
assignee != "John Smith" or reporter != "John Smith" |
- 查找所有还没有分配经办人的问题: 或
大于: > "> " 运算符用于差咋后比指定字段值大的问题。 不能用于 文本 字段。 注意 "> " 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。 示例 - Find all issues with more than 4 votes查找所有投票数大于4的问题:
- Find all overdue issues查找所有逾期未解决的问题:
代码块 |
---|
duedate < now() and resolution is empty |
- Find all issues where priority is higher than 查找所有优先级高于 "Normal"的问题:
锚 |
---|
| GREATER_THAN_EQUALS |
---|
| GREATER_THAN_EQUALS |
---|
|
GREATER THAN EQUALS大于等于: >= The ">= " operator is used to search for issues where the value of the specified field is greater than or equal to the specified value. Cannot be used with #text fields. 运算符用于查找大于等于指定字段值的问题。不能用于 文本 字段。 注意 Note that the ">= " operator can only be used with fields which support ordering (e.g. date fields and version fields). 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 To see a field's supported operators, check the individual #field reference. 示例 - Find all issues with 4 or more votes:
- Find all issues due on or after 31/12/2008:
代码块 |
---|
duedate >= "2008/12/31" |
- Find all issues created in the last five days:
LESS THAN小于: < The "< " operator is used to search for issues where the value of the specified field is less than the specified value. Cannot be used with #text fields. 不能用于 文本 字段。 Note that the "< " operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual #field reference. 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。 示例 - Find all issues with less than 4 votes:
锚 |
---|
| LESS_THAN_EQUALS |
---|
| LESS_THAN_EQUALS |
---|
|
LESS THAN EQUALS: <= The "<= " operator is used to search for issues where the value of the specified field is less than or equal to than the specified value. Cannot be used with #text fields. 不能用于 文本 字段。 Note that the "<= " operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual #field reference. 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。 示例 - Find all issues with 4 or fewer votes:
- Find all issues that have not been updated in the past month (30 days):
IN The "IN " operator is used to search for issues where the value of the specified field is one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses. Using "IN " is equivalent to using multiple #EQUALS (=) statements, but is shorter and more convenient. That is, typing reporter IN (tom, jane, harry) is the same as typing reporter = "tom" #OR reporter = "jane" #OR reporter = "harry" . 示例 - Find all issues that were created by either jsmith or jbrown or jjones:
代码块 |
---|
reporter in (jsmith,jbrown,jjones) |
- Find all issues where the Reporter or Assignee is either Jack or Jill:
代码块 |
---|
reporter in (Jack,Jill) or assignee in (Jack,Jill) |
- Find all issues in version 3.14 or version 4.2:
代码块 |
---|
affectedVersion in ("3.14", "4.2") |
NOT IN The "NOT IN " operator is used to search for issues where the value of the specified field is not one of multiple specified values. Using "NOT IN " is equivalent to using multiple #NOT_EQUALS (!=) statements, but is shorter and more convenient. That is, typing reporter NOT IN (tom, jane, harry) is the same as typing reporter != "tom" #AND reporter != "jane" #AND reporter != "harry" . 示例 - Find all issues where the Reporter is not Jack, Jill or John:
代码块 |
---|
reporter not in (Jack,Jill,John) |
- Find all issues where the FixVersion is not 'A', 'B', 'C' or 'D':
代码块 |
---|
FixVersion not in ( A, B, C, D) |
- Find all issues where the FixVersion is not 'A', 'B', 'C' or 'D', or has not been specified:
代码块 |
---|
FixVersion not in ( A, B, C, D) or FixVersion is empty |
CONTAINS: ~ The "~ " operator is used to search for issues where the value of the specified field matches the specified value (either an exact match or a "fuzzy" match — see examples below). For use with text fields only, i.e.: 包含页面 |
---|
| quickstart:__JQL Text Fields |
---|
| quickstart:__JQL Text Fields |
---|
nopanel | true |
---|
|
Note: when using the "~ " operator, the value on the right-hand side of the operator can be specified using JIRA text-search syntax. 示例 - Find all issues where the Summary contains the exact phrase "full screen":
代码块 |
---|
summary ~ "\"full screen\"" |
- Find all issues where the Summary contains the word "win" (or derivatives of that word, such as "windows" or "winning"):
锚 |
---|
| DOES_NOT_CONTAIN |
---|
| DOES_NOT_CONTAIN |
---|
|
DOES NOT CONTAIN: !~ The "!~ " operator is used to search for issues where the value of the specified field is not a "fuzzy" match for the specified value. For use with text fields only, i.e.: 包含页面 |
---|
| quickstart:__JQL Text Fields |
---|
| quickstart:__JQL Text Fields |
---|
nopanel | true |
---|
|
Note: when using the "!~ " operator, the value on the right-hand side of the operator can be specified using JIRA text-search syntax. 示例 - Find all issues where the Summary does not contain the word "run" (or derivatives of that word, such as "running" or "ran"):
IS The "IS " operator can only be used with #EMPTY or #NULL. That is, it is used to search for issues where the specified field has no value. Note that not all #fields are compatible with this operator; see the individual #field reference for details. 示例 - Find all issues that have no Fix Version: or
IS NOT The "IS NOT " operator can only be used with #EMPTY or #NULL. That is, it is used to search for issues where the specified field has a value. Note that not all #fields are compatible with this operator; see the individual #field reference for details. 示例 - Find all issues that have one or more votes: or
|