页面树结构

版本比较

标识

  • 该行被添加。
  • 该行被删除。
  • 格式已经改变。

...

内容区目录
maxLevel4
minLevel4
locationtop
typelist

EQUALS
EQUALS

等于: =

"=" 运算符用于查找精确匹配字段值的问题。 (注意: 不能用于 文本 字段; 文本字段的匹配条件请使用 包含 运算符。)

要精确匹配多个字段值,请使用与(AND)将多个 "=" 表达式连接起来。

示例
  • 查找由jsmith创建的所有问题:
    代码块
    reporter = jsmith
  • 查找由John Smith创建的所有问题:
    代码块
    reporter = "John Smith"

NOT_EQUALS
NOT_EQUALS

不等于: !=

"!=" 运算符用于查找不等于指定字段值之外的问题。 (注意: 不能用于 文本 字段; 文本字段的否定条件请使用 不包含 ("!~") 运算符。)

注意输入 field != value 与输入 NOT field = value}}具有同等效果, 并且 {{field != EMPTY 与 {{field #IS_NOT EMPTY}}也具有同等效果。

示例
  • 查找所有已经被分配经办人,但是经办人不是jsmith的问题:
    代码块
    not assignee = jsmith
    or:
    代码块
    assignee != jsmith
  • 查找报告人不是jsmith的所有问题:
    代码块
    reporter !=jsmith
  • 查找你报告的,但经办人没有被分配给你的问题:
    代码块
    reporter = currentUser() and assignee != currentUser()
  • 查找已经被分配经办人,但报告人或经办人不是John Smith的问题:
    代码块
    assignee != "John Smith" or reporter != "John Smith"
  • 查找所有还没有分配经办人的问题:
    代码块
    assignee is not empty
    代码块
    assignee != null

GREATER_THAN
GREATER_THAN

>
>

大于: >

">" 运算符用于差咋后比指定字段值大的问题。 不能用于 文本 字段。

注意 ">" 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。

示例
  • 查找所有投票数大于4的问题:
    代码块
    votes > 4
  • 查找所有逾期未解决的问题:
    代码块
    duedate < now() and resolution is empty
  • 查找所有优先级高于 "Normal"的问题:
    代码块
    priority > normal

GREATER_THAN_EQUALS
GREATER_THAN_EQUALS

>

大于等于: >=

">=" 运算符用于查找大于等于指定字段值的问题。不能用于 文本 字段。

注意 ">=" 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。

示例
  • 查找所有投票数大于等于 4 的问题:
    代码块
    votes >= 4
  • 查找到期日大于等于 31/12/2008 的问题:
    代码块
    duedate >= "2008/12/31"
  • 查找过去5天内创建的问题:
    代码块
    created >= "-5d"

LESS_THAN
LESS_THAN

<
<

小于: <

The "<" 运算符用于搜索小于指定字段值的问题。 不能用于 文本 字段。

注意"<" 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。

示例
  • 查找所有投票数小于 4 的问题:
    代码块
    votes < 4

LESS_THAN_EQUALS
LESS_THAN_EQUALS

<

小于等于: <=

The "<=" 运算符用于搜索小于等于指定字段值的问题。 不能用于 文本 字段。

注意 "<=" 运算符只能用于支持排序的字段 (例如 日期字段和版本字段等)。 要了解字段支持哪些运算符, 请查看每个 字段 参考。

示例
  • 查找所有投票数小于等于 4的问题:
    代码块
    votes <= 4
  • 查找过去一个月(30天)内没有更新的问题:
    代码块
    updated <= "-4w 2d"

IN
IN

在...之内 IN

"IN" 运算符用于查找多个指定字段值的问题。 多个值之间用逗号分隔, 用括号括起来。

使用 "IN" 运算符相当于多个 #EQUALS (=) 表达式, 但是使用起来更方便,更简短。 也就是说, 输入 reporter IN (tom, jane, harry) 与输入 {{reporter = "tom" #OR reporter = "jane" #OR reporter = "harry"}}具有同等效果。

示例
  • 查找报告人是jsmith或jbrown或jjones的所有问题:
    代码块
    reporter in (jsmith,jbrown,jjones)
  • 查找所有报告人或经办人是Jack或Jill的所有问题:
    代码块
    reporter in (Jack,Jill) or assignee in (Jack,Jill)
  • 查找影响版本是3.14 或 4.2的问题:
    代码块
    affectedVersion in ("3.14", "4.2")

NOT_IN
NOT_IN

不在...之内 NOT IN

"NOT IN" 运算符用于排除多个指定字段值的问题。

使用 "NOT IN" 运算符相当于多个 #NOT_EQUALS (!=) 表达式, 但是使用起来更方便,更简短。也就是说,输入 reporter NOT IN (tom, jane, harry) 与输入 {{reporter != "tom" #AND reporter != "jane" #AND reporter != "harry"}}具有相同的效果。

示例
  • 查找所有报告人不是Jack或不是Jill或不是John的问题:
    代码块
    reporter not in (Jack,Jill,John)
  • 查找修复版本不是 'A', 'B', 'C' 或不是 'D'的问题:
    代码块
    FixVersion not in ( A, B, C, D)
  • 查找修复版本不是'A', 'B', 'C' 或不是 'D'的问题, 或者没有指定修复版本值的问题:
    代码块
    FixVersion not in ( A, B, C, D) or FixVersion is empty

CONTAINS
CONTAINS

~
~

包含: ~

"~" 运算符用于匹配指定字段值的问题 (也可以使用精确匹配或 "模糊" 匹配 — 查看下面的示例)。 只能用于文本字段, 例如:

包含页面
quickstart:__JQL Text Fields
quickstart:__JQL Text Fields
nopaneltrue

注意: 使用 "~" 运算符, 在运算符右侧的字段值可以使用 JIRA 文本搜索语法

示例
  • 查找主题中包括"full screen"词组的问题:
    代码块
    summary ~ "\"full screen\""
  • 查找主题中包括 "win"单词 (或其衍生单词, 比如 "windows" 或 "winning")的问题:
    代码块
    summary ~ win

DOES_NOT_CONTAIN
DOES_NOT_CONTAIN

不包括: !~

"!~" 运算符用于模糊匹配不包含指定字符的问题。 只能用于文本字段, 例如:

包含页面
quickstart:__JQL Text Fields
quickstart:__JQL Text Fields
nopaneltrue

注意: 使用 "!~" 运算符, 在运算符右侧的字段值可以使用 JIRA 文本搜索语法

示例
  • 查找主题中不包括 "run"单词的问题 (或其衍生单词, 比如 "running" 或 "ran"):
    代码块
    summary !~ run

IS
IS

是 IS

"IS" 运算符只能与 空(EMPTY)空(NULL)结合使用。 也就是说搜索指定字段没有赋值的问题。

注意不是所有的 字段 都可以使用这个运算符; 分别查看所有的 字段 参考了解具体用法。

示例
  • 查找修复版本没有赋值的所有问题:
    代码块
    fixVersion is empty
    or
    代码块
    fixVersion is null

IS_NOT
IS_NOT

不是 IS NOT

"IS NOT" 运算符只能与 空(EMPTY)空(NULL)结合使用。也就是说搜索指定字段已经被赋值的问题。

注意不是所有的 字段 都可以使用这个运算符; 分别查看所有的 字段 参考了解具体用法。

示例
  • 查找所有被投票的问题:
    代码块
    votes is not empty
    代码块
    votes is not null

...

内容区目录
maxLevel4
minLevel4
locationtop
typelist

affectedVersion
affectedVersion

AffectedVersion
AffectedVersion

影响版本

搜索指定影响版本的问题。 你可以按照版本名称或版本ID(JIRA自动为版本分配的数值)搜索 。

信息
title按照版本ID搜索比按照版本名称搜索更准确

不同的项目可能有相同名称的版本, 所有按照版本名称搜索可能会搜索到多个项目的问题。 当JIRA管理员更改版本的名称, 会使依赖版本名称的 过滤器 失效。 Version ID是唯一且无法修改的。

注意: 这个字段支持 自动完成

语法
代码块
affectedVersion
字段类型

版本 VERSION

支持的操作符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue

注意比较运算符 (如 ">") 使用 版本排序(链接到Atlassian网站) 只按照JIRA管理员设置的顺序, 而不按照数值或字母顺序。

支持的函数

当使用 在...之内(IN)不在...之内(NOT IN) 运算符时, affectedVersion 支持:

示例
  • 查找影响版本是 3.14的问题:
    代码块
    affectedVersion = "3.14"
    (注意点(.)是保留 #字符, 所以你需要用引号括起来。)
  • 查找影响版本是"Big Ted"的问题:
    代码块
    affectedVersion = "Big Ted"
  • 查找影响版本ID是 10350的问题:
    代码块
    affectedVersion = 10350

Assignee
Assignee

经办人

搜索经办人是指定用户的问题。 你可以使用用户全名、ID或电子邮件地址。

注意: 这个字段支持 自动完成

语法
代码块
assignee
字段类型

用户 USER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

当使用 #IN#NOT_IN 运算符时, assignee 支持:

When used with the #EQUALS and #NOT_EQUALS operators, assignee supports:

当使用 等于不等于 运算符时, assignee 支持:

示例
  • Search for issues that are assigned to John Smith搜索分配给John Smith的问题:
    代码块
    assignee = "John Smith"
    or
    代码块
    assignee = jsmith
  • Search for issues that are assigned by the user with email address 搜索经办人邮件地址是 "bob@mycompany.com"的问题:
    代码块
    assignee = "bob@mycompany.com"
    (Note that full-stops and (注意句号(.)和 "@" symbols are reserved #characters, so the email address needs to be surrounded by quote-marks.符号是保留 #字符, 所以需要用引号将邮件地址括起来。)

Category
Category

Category

Search for issues that belong to projects in a particular Category.

类别

搜索属于指定项目类别的项目下的所有问题。

注意: 这个字段支持 自动完成Note: this field supports #auto-complete.

语法
代码块
category
字段类型

类别 CATEGORY

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues that belong to projects in the "Alphabet Projects" Category搜索属于 "内部项目"类别下的所有问题:
    代码块
     category = "Alphabet Projects内部项目"

Comment
Comment

Comments
Comments

Comment

Search for issues that have a Comment which contains particular text.

JIRA text-search syntax can be used.

备注

搜索备注中包含指定字符的问题。

可以使用JIRA 文本搜索语法

注意: 这个字段不支持 自动完成Note: this field does not support #auto-complete.

语法
代码块
comment
字段类型

文本 TEXT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Text Fields (excluding IS)
quickstart:__JQL Operators supported by Text Fields (excluding IS)
nopaneltrue
支持的函数

n/a

示例
  • Find issues where a Comment contains text that matches 查找备注中包含 "My PC is quite old" (i.e. a "fuzzy" match字符的问题 例如 "模糊" 匹配:
    代码块
    comment ~ "My PC is quite old"
  • Find issues where a Comment contains the exact phrase 查找备注中精确匹配 "My PC is quite old"的问题:
    代码块
    comment ~ "\"My PC is quite old\""

ComponentComponent

Component

Search for issues that belong to a particular component(s) of a project. You can search by component name or component ID (i.e. the number that JIRA automatically allocates to a component).

Component
Component

模块

搜索一个项目中的指定 模块的问题。 你可以按照模块名称或模块ID (JIRA自动分配给模块的数字)搜索。

信息
title搜索模块ID搜索比搜索模块名称更准确

不同的项目可能有相同的模块名称, 所以按照模块名称搜索可能会返回多个项目的问题。 JIRA管理员一旦修改了模块名称, 以模块名称为条件的 过滤器将无法使用。 模块ID是唯一且不能修改的。

信息
titleIt is safer to search by component ID than by component name

Different projects may have components with the same name, so searching by component name may return issues from multiple projects. It is also possible for your JIRA administrator to change the name of a component, which could break any saved filters which rely on that name. Component IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
component
字段类型

模块 COMPONENT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

When used with the #IN and #NOT_IN operators, component supports: 当使用 在...之内(IN)不在...之内(NOT IN) 运算符时, component 支持:

示例
  • Find issues in the 查找模块是 "Comp1" or "Comp2" component的问题:
    代码块
     component in (Comp1, Comp2)
  • Find issues in the 查找模块是 "Comp1" and 并且"Comp2" components的问题:
    代码块
     component in (Comp1) and component in (Comp2)
    or
    代码块
     component = Comp1 and component = Comp2
  • Find issues in the component with ID 20500查找模块ID是 20500的问题:
    代码块
    component = 20500

Created
Created

CreatedDate
CreatedDate

createdDatecreatedDate

Created

createdDate

创建日期

按照指定的创建日期范围搜索问题。 Search for issues that were created on, before or after a particular date (or date range).

包含页面
quickstart:__JQL Date Formats
quickstart:__JQL Date Formats
nopaneltrue

Note: this field does not support #auto-complete. 注意: 这个字段不支持 自动完成

语法
代码块
created

Alias或者:

代码块
createdDate
字段类型

日期 DATE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators, createdDate supports: 当使用 等于, 不等于, 大于, 大于等于, 小于小于等于 运算符时, createdDate 支持:

示例
  • Find all issues created on or before 12th December 2008 查找2008年12月12日 00:00之前创建的问题(包括00:00):
    代码块
    created <= "2008/12/12"
  • Find issues created less than one day ago查找1天以前创建的问题:
    代码块
    created > "-1d"
  • Find issues created in January 2009查找2009年1月创建的问题:
    代码块
    created > "2008/12/31" and created < "2009/02/01"
  • Find issues created on 15 January 2009查找2009年1月15日创建的问题:
    代码块
    created > "2009/01/14" and created < "2009/01/16"

custom
custom

Custom Field

自定义字段

Only applicable if your JIRA administrator has created one or more Custom Fields.

Search for issues where a particular Custom Field has a particular value.

You can search by Custom Field name or Custom Field ID (i.e. the number that JIRA automatically allocates to an Custom Field).

信息
titleIt is safer to search by Custom Field ID than by Custom Field name

It is possible for a Custom Field to have the same name as a built-in JIRA system field, in which case JIRA will search on the system field (not your custom field). It is also possible for your JIRA administrator to change the name of a Custom Field, which could break any saved filters which rely on that name. Custom Field IDs, however, are unique and cannot be changed.

Note:

  • JIRA text-search syntax can be used with Custom Fields of type 'Text'.
  • #auto-complete is supported for Custom Fields of type picker, group picker, select (except 'Cascading Select'), check-box and radio button fields.
语法
代码块
CustomFieldName

Alias:

代码块
cf[CustomFieldID]
字段类型

Depends on the Custom Field's configuration

支持的运算符

Different types of Custom Fields support different #operators. For the default Custom Field Types, the following operators are supported:

  • Number and date/time fields:
    包含页面
    quickstart:__JQL Operators supported by Numeric Fields
    quickstart:__JQL Operators supported by Numeric Fields
    nopaneltrue
  • Picker, select, check-box and radio button fields:
    包含页面
    quickstart:__JQL Operators supported by Select Fields
    quickstart:__JQL Operators supported by Select Fields
    nopaneltrue
  • Text fields:
    包含页面
    quickstart:__JQL Operators supported by Text Fields
    quickstart:__JQL Operators supported by Text Fields
    nopaneltrue
支持的函数

Different types of Custom Fields support different #functions. For the default Custom Field Types, the following functions are supported:

示例
  • Find issues where the value of the "Location" Custom Field is "New York":
    代码块
    location = "New York"
  • Find issues where the value of the Custom Field with ID 10003 is "New York":
    代码块
    cf[10003] = "New York"
  • Find issues where the value of the "Location" Custom Field is "London" or "Milan" or "Paris":
    代码块
    cf[10003] in ("London", "Milan", "Paris")
  • Find issues where the "Location" Custom Field has no value:
    代码块
    location != empty

Description
Description

Description

Search for issues where the Description contains particular text.

JIRA text-search syntax can be used.

Note: this field does not support #auto-complete.

语法
代码块
description
字段类型

TEXT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Text Fields
quickstart:__JQL Operators supported by Text Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues where the Description contains text that matches "Please see screenshot" (i.e. a "fuzzy" match):
    代码块
    description ~ "Please see screenshot"
  • Find issues where the Description contains the exact phrase "Please see screenshot":
    代码块
    description ~ "\"Please see screenshot\""

Due
Due

DueDate
DueDate

dueDate
dueDate

Due

Search for issues that were due on, before or after a particular date (or date range).

包含页面
quickstart:__JQL Date Formats
quickstart:__JQL Date Formats
nopaneltrue

Note that Due Date relates to the date only (not to the time).

Note: this field does not support #auto-complete.

语法
代码块
due

Alias:

代码块
dueDate
字段类型

DATE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators, dueDate supports:

示例
  • Find all issues due on or before 31st December 2008:
    代码块
    due <= "2008/12/31"
  • Find issues that are due tomorrow:
    代码块
    due = "1d"
  • Find issues that were due in January 2009:
    代码块
    due > "2008/12/31" and due < "2009/02/01"
  • Find issues that were due on 15 January 2009:
    代码块
    due > "2009/01/14" and due < "2009/01/16"

Environment
Environment

Environment

Search for issues where the Environment contains particular text.

JIRA text-search syntax can be used.

Note: this field does not support #auto-complete.

语法
代码块
environment
字段类型

TEXT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Text Fields
quickstart:__JQL Operators supported by Text Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues where the Environment contains text that matches "Third floor" (i.e. a "fuzzy" match):
    代码块
    environment ~ "Third floor"
  • Find issues where the Environment contains the exact phrase "Third floor":
    代码块
    environment ~ "\"Third floor\""

filter
filter

Filter

You can use a saved filter to narrow your search. You can search by filter name or filter ID (i.e. the number that JIRA automatically allocates to a saved filter).

信息
titleIt is safer to search by filter ID than by filter name

It is possible for a filter name to be changed, which could break a saved filter that invokes another filter by name. Filter IDs, however, are unique and cannot be changed.

Note:

  • An #ORDER BY statement in your typed query will override an ORDER BY statement in the saved filter.
  • You cannot run or save a filter that would cause an infinite loop (i.e. you cannot reference a saved filter if it eventually references your current filter).
  • This field supports #auto-complete.
    语法
    代码块
    filter
    Aliases:
    代码块
    request
    代码块
    savedFilter
    代码块
    searchRequest
字段类型

FILTER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields (excluding IS)
quickstart:__JQL Operators supported by Select Fields (excluding IS)
nopaneltrue
支持的函数

n/a

示例
  • Search the results of the filter "My Saved Filter" (which has an ID of 12000) for issues assigned to the user jsmith:
    代码块
    filter = "My Saved Filter" and assignee = jsmith
    or
    代码块
    filter = 12000 and assignee = jsmith

FixVersion
FixVersion

fixVersion
fixVersion

Fix Version

Search for issues that are assigned to a particular Fix Version. You can search by version name or version ID (i.e. the number that JIRA automatically allocates to a version).

信息
titleIt is safer to search by version ID than by version name

Different projects may have versions with the same name, so searching by version name may return issues from multiple projects. It is also possible for your JIRA administrator to change the name of a version, which could break any saved filters that rely on that name. Version IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
fixVersion
字段类型

VERSION

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue

Note that the comparison operators (e.g. ">") use the version order that has been set up by your project administrator, not a numeric or alphabetic order.

支持的函数

When used with the #IN and #NOT_IN operators, fixVersion supports:

示例
  • Find issues with a Fix Version of 3.14 or 4.2:
    代码块
     fixVersion in ("3.14", "4.2")
    (Note that full-stops are reserved #characters, so they need to be surrounded by quote marks.)
  • Find issues with a Fix Version of "Little Ted":
    代码块
    fixVersion = "Little Ted"
  • Find issues with a Fix Version ID of 10001:
    代码块
    fixVersion = 10001

Issue
Issue

Issue Key

Search for issues with a particular Issue Key or Issue ID (i.e. the number that JIRA automatically allocates to an Issue).

Note: this field does not support #auto-complete.

语法
代码块
issueKey

Aliases:

代码块
id
代码块
issue
代码块
key
字段类型

ISSUE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

When used with the #IN or #NOT_IN operators, issueKey supports:

示例
  • Find the issue with key "ABC-123":
    代码块
    issueKey = ABC-123 

Level
Level

Level

Only available if Issue Level Security has been enabled by your JIRA administrator.

Search for issues with a particular Security Level. You can search by Issue Security Level name or Issue Security Level ID (i.e. the number that JIRA automatically allocates to an Issue Security Level).

信息
titleIt is safer to search by Security Level ID than by Security Level name

It is possible for your JIRA administrator to change the name of a Security Level, which could break any saved filter which rely on that name. Security Level IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
level
字段类型

SECURITY LEVEL

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

n/a

示例
  • Search for issues with a Security Level of "Really High" or "level1":
    代码块
    level in ("Really High", level1)
  • Search for issues with a Security Level ID of 123:
    代码块
    level = 123

originalEstimate
originalEstimate

OriginalEstimate
OriginalEstimate

Original Estimate

Only available if time-tracking has been enabled by your JIRA administrator.

Search for issues where the Original Estimate is set to a particular value (i.e. a number, not a date or date range).

Use "w", "d", "h" and "m" to specify weeks, days, hours or minutes.

Note: this field does not support #auto-complete.

语法
代码块
originalEstimate

Alias:

代码块
timeOriginalEstimate
字段类型

DURATION

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with an Original Estimate of 1 hour:
    代码块
    originalEstimate = 1h
  • Find issues with an Original Estimate of more than 2 days:
    代码块
    originalEstimate > 2d

Parent
Parent

Parent

Only available if sub-tasks have been enabled by your JIRA administrator.

Search for all sub-tasks of a particular issue. You can search by Issue Key or by Issue ID (i.e. the number that JIRA automatically allocates to an Issue).

Note: this field does not support #auto-complete.

语法
代码块
parent
字段类型

ISSUE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields (excluding IS)
quickstart:__JQL Operators supported by Select Fields (excluding IS)
nopaneltrue
支持的函数

n/a

示例
  • Find issues that are sub-tasks of issue TEST-1234:
    代码块
    parent = TEST-1234

Priority
Priority

Priority

Search for issues with a particular Priority. You can search by Priority name or Priority ID (i.e. the number that JIRA automatically allocates to a Priority).

信息
titleIt is safer to search by Priorty ID than by Priority name

It is possible for your JIRA administrator to change the name of a Priority, which could break any saved filter which rely on that name. Priority IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
priority
字段类型

PRIORITY

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with a Priority of "High":
    代码块
     priority = High
  • Find issues with a Priority ID of 10000:
    代码块
    priority = 10000

Project
Project

Project

Search for issues that belong to a particular Project

You can search by Project Name, by Project Key or by Project ID (i.e. the number that JIRA automatically allocates to a project).

注意: 这个字段支持自动完成

语法
代码块
project
字段类型

PROJECT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

When used with the #IN and #NOT_IN operators, project supports:

示例
  • Find issues that belong to the Project that has the name "ABC Project":
    代码块
     project = "ABC Project" 
  • Find issues that belong to the Project that has the key "ABC":
    代码块
    project = "ABC"
  • Find issues that belong to the Project that has the ID "1234":
    代码块
    project = 1234

remainingEstimate
remainingEstimate

RemainingEstimate
RemainingEstimate

Remaining Estimate

Only available if time-tracking has been enabled by your JIRA administrator.

Search for issues where the Remaining Estimate is set to a particular value (i.e. a number, not a date or date range).

Use "w", "d", "h" and "m" to specify weeks, days, hours or minutes.

Note: this field does not support #auto-complete.

语法
代码块
remainingEstimate

Alias:

代码块
timeEstimate
字段类型

DURATION

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with a Remaining Estimate of more than 4 hours:
    代码块
     remainingEstimate > 4h 

Reporter
Reporter

Reporter

Search for issues that were reported by (i.e. created by) a particular user.

You can search by the user's Full Name, ID or Email Address.

注意: 这个字段支持自动完成

语法
代码块
reporter
字段类型

USER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

When used with the #IN and #NOT_IN operators, reporter supports:

When used with the #EQUALS and #NOT_EQUALS operators, reporter supports:

示例
  • Search for issues that were created by Jill Jones:
    代码块
    reporter = "Jill Jones"
    or
    代码块
    reporter = jjones
  • Search for issues that were created by the user with email address "bob@mycompany.com":
    代码块
    assignee = "bob@mycompany.com"
    (Note that full-stops and "@" symbols are reserved #characters, so the email address needs to be surrounded by quote-marks.)

Resolution
Resolution

Resolution

Search for issues that have a particular Resolution

You can search by Resolution name or Resolution ID (i.e. the number that JIRA automatically allocates to a Resolution).

信息
titleIt is safer to search by Resolution ID than Resolution name

It is possible for your JIRA administrator to change the name of a Resolution, which could break any saved filter which rely on that name. Resolution IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
resolution
字段类型

RESOLUTION

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with a Resolution of "Cannot Reproduce" or "Won't Fix":
    代码块
     resolution in ("Cannot Reproduce", "Won't Fix")
  • Find issues with a Resolution ID of 5:
    代码块
    resolution = 5
  • Find issues that do not have a Resolution:
    代码块
    resolution = unresolved

Resolved
Resolved

ResolutionDate
ResolutionDate

resolutionDate
resolutionDate

Resolved

Search for issues that were resolved on, before or after a particular date (or date range).

包含页面
quickstart:__JQL Date Formats
quickstart:__JQL Date Formats
nopaneltrue

Note: this field does not support #auto-complete.

语法
代码块
resolved

Alias:

代码块
resolutionDate
字段类型

DATE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators, resolved supports:

示例
  • Find all issues that were resolved on or before 31st December 2008 00:00:
    代码块
    resolved <= "2008/12/31"
  • Find issues that were resolved in January 2009:
    代码块
    resolved > "2008/12/31" and resolved < "2009/02/01"
  • Find issues that were resolved on 15 January 2009:
    代码块
    resolved > "2009/01/14" and resolved < "2009/01/16"
  • Find issues that were resolved in the last hour:
    代码块
    resolved > -1h

Status
Status

Status

Search for issues that have a particular Status.

You can search by Status name or Status ID (i.e. the number that JIRA automatically allocates to a Status).

信息
titleIt is safer to search by Status ID than Status name

It is possible for your JIRA administrator to change the name of a Status which could break any saved filter which rely on that name. Status IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
status
字段类型

STATUS

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with a Status of "Open":
    代码块
     status = Open
  • Find issues with a Status ID of 1:
    代码块
    status = 1

Summary
Summary

Summary

Search for issues where the Summary contains particular text.

JIRA text-search syntax can be used.

Note: this field does not support #auto-complete.

语法
代码块
summary
字段类型

TEXT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Text Fields
quickstart:__JQL Operators supported by Text Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues where the Summary contains text that matches "Error saving file" (i.e. a "fuzzy" match):
    代码块
    summary ~ "Error saving file"
  • Find issues where the Summary contains the exact phrase "Error saving file":
    代码块
    summary ~ "\"Error saving file\""

text
text

Text
Text

Text

This is a "master-field" that allows you to search all text fields, i.e.:

包含页面
quickstart:__JQL Text Fields
quickstart:__JQL Text Fields
nopaneltrue

Note: The text master-field can only be used with the #CONTAINS operator ("~" and "!~").

语法
代码块
text
字段类型

TEXT

支持的运算符
包含页面
quickstart:__JQL Operators supported by Text Fields (excluding IS and NOT)
quickstart:__JQL Operators supported by Text Fields (excluding IS and NOT)
nopaneltrue
支持的函数

n/a

示例
  • Find issues where a text field matches the word "Fred":
    代码块
    text ~ "Fred"
    or
    代码块
    text ~ Fred
  • Find all issues where a text field contains the exact phrase "full screen":
    代码块
    text ~ "\"full screen\""

Type
Type

Type

Search for issues that have a particular Issue Type.

You can search by Issue Type name or Issue Type ID (i.e. the number that JIRA automatically allocates to an Issue Type).

信息
titleIt is safer to search by Type ID than Type name

It is possible for your JIRA administrator to change the name of a Type, which could break any saved filter which rely on that name. Type IDs, however, are unique and cannot be changed.

注意: 这个字段支持自动完成

语法
代码块
type

Alias:

代码块
issueType
字段类型

ISSUE_TYPE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues with an Issue Type of "Bug":
    代码块
    type = Bug
  • Find issues with an Issue Type of "Bug" or "Improvement":
    代码块
     issueType in (Bug,Improvement)
  • Find issues with an Issue Type ID of 2:
    代码块
    issueType = 2

TimeSpent
TimeSpent

timeSpent
timeSpent

Time Spent

Only available if time-tracking has been enabled by your JIRA administrator.

Search for issues where the Time Spent is set to a particular value (i.e. a number, not a date or date range).

Use "w", "d", "h" and "m" to specify weeks, days, hours or minutes.

Note: this field does not support #auto-complete.

语法
代码块
timeSpent
字段类型

DURATION

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues where the Time Spent is more than 5 days:
    代码块
    timeSpent > 5d

Updated
Updated

UpdatedDate
UpdatedDate

updatedDate
updatedDate

Updated

Search for issues that were last updated on, before or after a particular date (or date range).

包含页面
quickstart:__JQL Date Formats
quickstart:__JQL Date Formats
nopaneltrue

Note: this field does not support #auto-complete.

语法
代码块
updated

Alias:

代码块
updatedDate
字段类型

DATE

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators, updated supports:

示例
  • Find issues that were updated on or before 12th December 2008 00:00:
    代码块
    updated <= "2008/12/12"
  • Find issues that were updated more than two weeks ago:
    代码块
    updated < "-2w"
  • Find issues that were updated on 15 January 2009:
    代码块
    updated > "2009/01/14" and updated < "2009/01/16"
  • Find issues that were updated in January 2009:
    代码块
    updated > "2008/12/31" and updated < "2009/02/01"

voter
voter

Voter
Voter

Voter

Search for issues for which a particular user has voted. You can search by the user's Full Name, ID or Email Address. 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. See also #votedIssues.

注意: 这个字段支持自动完成

语法
代码块
voter
字段类型

USER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

When used with the #IN and #NOT_IN operators, voter supports:

When used with the #EQUALS and #NOT_EQUALS operators, voter supports:

示例
  • Search for issues for which you have voted:
    代码块
    voter = currentUser()
  • Search for issues for which the user "jsmith" has voted:
    代码块
    voter = "jsmith"
  • Search for issues for which a member of the group "jira-developers" has voted:
    代码块
    voter in membersOf("jira-developers")

Votes
Votes

Votes

Search for issues with a specified number of votes.

Note: this field does not support #auto-complete.

语法
代码块
votes
字段类型

NUMBER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields (excluding IS)
quickstart:__JQL Operators supported by Numeric Fields (excluding IS)
nopaneltrue
支持的函数

n/a

示例
  • Find all issues that have 12 or more votes:
    代码块
    votes >= 12

watcher
watcher

Watcher
Watcher

Watcher

Search for issues that a particular user is watching. You can search by the user's Full Name, ID or Email Address. Note that you can only find issues for which you have the "View Voters and Watchers" permission, unless you are searching for issues where you are the watcher. See also #watchedIssues.

注意: 这个字段支持自动完成

语法
代码块
voter
字段类型

USER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Select Fields
quickstart:__JQL Operators supported by Select Fields
nopaneltrue
支持的函数

When used with the #IN and #NOT_IN operators, watcher supports:

When used with the #EQUALS and #NOT_EQUALS operators, watcher supports:

示例
  • Search for issues that you are watching:
    代码块
    watcher = currentUser()
  • Search for issues that the user "jsmith" is watching:
    代码块
    watcher = "jsmith"
  • Search for issues that are being watched by a member of the group "jira-developers":
    代码块
    watcher in membersOf("jira-developers")

WorkRatio
WorkRatio

workRatio
workRatio

Work Ratio

Only available if time-tracking has been enabled by your JIRA administrator.

Search for issues where the Work Ratio has a particular value.

Work Ratio is calculated as follows: workRatio = #timeSpent / #originalEstimate) x 100

Note: this field does not support #auto-complete.

语法
代码块
workRatio
字段类型

NUMBER

支持的运算符
包含页面
quickstart:__JQL Operators supported by Numeric Fields
quickstart:__JQL Operators supported by Numeric Fields
nopaneltrue
支持的函数

n/a

示例
  • Find issues on which more than 75% of the Original Estimate has been spent:
    代码块
     workRatio > 75

...

Note that there is an additional list of reserved characters for Text Searches, which applies to the following fields:

包含页面
quickstart:__JQL Text Fields
quickstart:__JQL Text Fields
nopaneltrue
.

words
words

保留字符

JQL保留一些专用的单词JQL保留了一些专用的单词. 如果你需要在查询语句中使用下面的单词,必须用引号将其括起来:

...