On this page本页面的内容:

maxLevel	2
minLevel	1

What is an Advanced Search?

An advanced search allows you to use structured queries to search for JIRA issues. Your search results will be displayed in the Issue Navigator, where you can export them to MS Excel and many other formats. You can also save and subscribe to your advanced searches if you wish.

什么是高级搜索?

通过高级搜索，你可以使用结构化查询语言搜索JIRA的问题。搜索的结果会显示在问题导航器中, 然后你可以将搜索结果输出为 MS Excel格式以及其他格式。你还可以保存以及订阅搜索结果。

查询语句由一个字段, 运算符, 和值或 _函数_构成。例如, 下面的查询语句将返回 "TEST"项目的所有问题A query consists of a #field, followed by an #operator, followed by a value or #function. For example, the following query will find all issues in the "TEST" project:

代码块
project = "TEST"

(This example uses the #Project field, the #EQUALS operator, and the value (这个例子使用了项目(project) 字段, 等于符号, 和值 "TEST".。)

Note that it is not possible to compare two #fields.

注意不能比较两个字段。

当你执行高级搜索时, 你使用的是JIRA查询语言(JQL)。 JQL类似SQL表达式, 比如 > 和 NULL。当然, 你不能使用数据库查询语言; 例如, JQL不能使用 SELECT 表达式。When you perform an advanced search, you are using the JIRA Query Language (JQL). JQL gives you some SQL-like statements, such as #> and #NULL. It is not, however, a database query language; for example, JQL does not have a SELECT statement.

锚

	Query
	Query

How to Perform an Advanced Search

如何使用高级搜索

点击顶部导航菜单栏的'问题'标签链接。会显示搜索页面。
点击 "高级"搜索模式链接。会显示 "查询" 框:
Image Added
使用下面描述的字段, 运算符和值或函数，书写查询语句。
点击"搜索" 按钮执行查询语句。
On the top navigation bar, click the "Issues" tab. This will display the Search panel.
Click "advanced". This will display the "Query" box:
Image Removed
Type your query using the #fields, #operators and field values or #functions listed below.
Click the "Search" button to run your query.

锚

	keyword
	keyword

锚

	keywords
	keywords

...

关键字

内容区目录

maxLevel	4
minLevel	4
location	top
type	list

锚

	AND
	AND

与 AND

Used to combine multiple statements, allowing you to refine your search.

Note that you can use #parentheses to control the order in which statements are executed.

Examples

用于整合多个查询条件, 允许你精炼查询条件。

注意，你可以使用括号来控制查询条件的执行顺序。

示例

查询
Find all open issues in the
"New office"
project
项目中所有开放的问题:
代码块
project = "New office" and status = "open"
Find all open, urgent issues that are assigned to jsmith
查询所有分配给jsmith的紧急的开放问题:
代码块
status = open and priority = urgent and assignee = jsmith
Find all issues in a particular project that are not assigned to jsmith
查询JRA项目中没有分配给jsmith的问题:
代码块
project = JRA and assignee != jsmith
Find all issues for a specific release which consists of different version numbers across several projects
查找JRA和CONF项目中修复版本是3.14的问题:
代码块
project in (JRA,CONF) and fixVersion = "3.14"
Find all issues where neither the Reporter nor the Assignee is Jack
查找不是Jack,Jill
or John
,John报告的并且他们也不是经办人的问题:
代码块
reporter not in (Jack,Jill,John) and assignee not in (Jack,Jill,John)

锚

	OR
	OR

或 OR

Used to combine multiple statements, allowing you to expand your search.

Note that you can use #parentheses to control the order in which statements are executed.

(Note: also see #IN, which can be a more convenient way to search for multiple values of a field.)

Examples

用户整合多个查询条件, 允许你扩展查询条件。

注意，你可以使用括号来控制查询条件的执行顺序。

(注意: 请参阅在...之中(IN)章节, 使用更方便的方法搜索多个字段的值。)

示例

搜索报告人是jsmith或jbrown的问题
Find all issues that were created by either jsmith or jbrown
:
代码块
reporter = jsmith or reporter = jbrown
Find all issues that are overdue or where no due date is set
搜索已近逾期或没有设置到期日的问题:
代码块
duedate < now() or duedate is empty

锚

	NOT
	NOT

非 NOT

Used to negate individual operators or entire statements of a query, allowing you to refine your search.

Note that you can use #parentheses to control the order in which statements are executed.

用于否定一个运算符或整个查询条件, 允许你优化查询条件。

注意，你可以使用括号来控制查询条件的执行顺序。

(注意: 请参阅不等于 (Note: also see #NOT_EQUALS ("!="), #DOES_NOT_CONTAIN 不包括 ("!~"), #NOT_IN and #IS_NOT.)

Examples

不再...之中和不是章节)

示例

搜索经办人不是jsmith的所有问题
Find all issues that are assigned to any user except jsmith
:
代码块
not assignee = jsmith
Find all issues that were not created by either jsmith or jbrown
搜索所有报告人不是jsmith或不是jbrown的问题:
代码块
not (reporter = jsmith or reporter = jbrown)

锚

	EMPTY
	EMPTY

EMPTY

Used to search for issues where a given field does not have a value. See also #NULL.

Note that EMPTY can only be used with fields that support the #IS and #IS_NOT operators. To see a field's supported operators, check the individual #field reference.

Examples

空 EMPTY

用于搜索没有值的字段。请参阅空(NULL)。

注意 EMPTY 只能与是(IS) 和不是(IS NOT) 运算符结合使用。要查看字段支持的运算符, 点击字段。

示例

搜索所有没有到期日(DueDate)的问题
Find all issues without a #DueDate
:
代码块
duedate = empty
or
或
代码块
duedate is empty

锚

	NULL
	NULL

NULL

Used to search for issues where a given field does not have a value. See also #EMPTY.

Note that NULL can only be used with fields that support the #IS and #IS_NOT operators. To see a field's supported operators, check the individual #field reference.

Examples

空 NULL

用于搜索字段没有赋值的问题。请查看空(EMPTY)。

注意 NULL 只能用于支持是(IS) 和不是(IS NOT) 操作符的字段。要了解字段支持哪些操作符, 请查看每个字段参考。

示例

查找所有没有设置到期日(DueDate)的问题
Find all issues without a #DueDate
:
代码块
duedate = null
or
或
代码块
duedate is null

锚

	ORDER_BY
	ORDER_BY

排序 ORDER BY

Used to specify the fields by whose values the search results will be sorted.

用于对输出的结果，按照指定的字段排序。

默认情况下, 按照字段输出顺序排序。你可以指定按照升序 (By default, the field's own sorting order will be used. You can override this by specifying ascending order ("asc") or descending order 或降序 ("desc"). 排列。

Examples

示例

查找所有没有设置到期日(DueDate)的问题, 按照创建日期(CreationDate)排序
Find all issues without a #DueDate, sorted by #CreationDate
:
代码块
duedate = empty order by created
Find all issues without a #DueDate, sorted by #CreationDate, then by #Priority (highest to lowest)
查找所有没有设置到期日(DueDate)的问题，先按照创建日期(CreationDate)排序，再按照优先级(Priority) (从高到低)排列:
代码块
duedate = empty order by created, priority desc
Find all issues without a #DueDate, sorted by #CreationDate, then by #Priority (lowest to highest)
查找所有没有设置到期日(DueDate)的问题，先按照创建日期(CreationDate)排序，再按照优先级(Priority)(从低到高)排列:
代码块
duedate = empty order by created, priority asc

锚

	operator
	operator

锚

	operators
	operators

...

运算符参考

内容区目录

maxLevel	4
minLevel	4
location	top
type	list

锚

	EQUALS
	EQUALS

锚

EQUALS

等于: =

The "=" operator is used to search for issues where the value of the specified field exactly matches the specified value. (Note: cannot be used with #text fields; see the #CONTAINS operator instead.)

To find issues where the value of a specified field exactly matches multiple values, use multiple "=" statements with the #AND operator.

Examples

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

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

示例

查找由jsmith创建的所有问题
Find all issues that were created by jsmith
:
代码块
reporter = jsmith
Find all issues
that were created by John Smith
查找由John Smith创建的所有问题:
代码块
reporter = "John Smith"

锚

	NOT_EQUALS
	NOT_EQUALS

NOT EQUALS

不等于: !=

The "!=" operator is used to search for issues where the value of the specified field does not match the specified value. (Note: cannot be used with #text fields; see the #DOES_NOT_MATCH 运算符用于查找不等于指定字段值之外的问题。 (注意: 不能用于文本字段; 文本字段的否定条件请使用不包含 ("!~") operator instead.运算符。)

Note that typing 注意输入 field != value is the same as typing 与输入 NOT field = value, and that }}具有同等效果, 并且 {{field != EMPTY is the same as field #IS 与 {{field IS_NOT EMPTY. }}也具有同等效果。

Examples

示例

查找所有已经被分配经办人，但是经办人不是jsmith的问题
Find all issues that are assigned to any user except jsmith
:
代码块
not assignee = jsmith
or:
代码块
assignee != jsmith
Find all issues that were not reported by jsmith
查找报告人不是jsmith的所有问题:
代码块
reporter !=jsmith
Find all issues that were reported by me but are not assigned to me
查找你报告的，但经办人没有被分配给你的问题:
代码块
reporter = currentUser() and assignee != currentUser()
查找已经被分配经办人，但报告人或经办人不是John Smith的问题:
Find all issues where the Reporter or Assignee is anyone except John Smith:
代码块
assignee != "John Smith" or reporter != "John Smith"
Find all issues that are not unassigned
查找所有还没有分配经办人的问题:
代码块
assignee is not empty
or
或
代码块
assignee != null

锚

	GREATER_THAN
	GREATER_THAN

锚

	>
	>

GREATER THAN

大于: >

The ">" operator is used to search for issues where the value of the specified field is greater 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.

Examples

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

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

示例

查找所有投票数大于4的问题
Find all issues with more than 4 votes
:
代码块
votes > 4
Find all overdue issues
查找所有逾期未解决的问题:
代码块
duedate < now() and resolution is empty
Find all issues where priority is higher than
查找所有优先级高于 "Normal"的问题:
代码块
priority > 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.

Examples

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

示例

查找所有投票数大于等于 4 的问题
Find all issues with 4 or more votes
:
代码块
votes >= 4
Find all issues due on or after 31/
查找到期日大于等于 31/12/2008 的问题:
代码块
duedate >= "2008/12/31"
Find all issues created in the last five days
查找过去5天内创建的问题:
代码块
created >= "-5d"

锚

	LESS_THAN
	LESS_THAN

锚

	<
	<

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.

Examples

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

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

示例

查找所有投票数小于 4 的问题
Find all issues with less than 4 votes
:
代码块
votes < 4

锚

	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.

Examples

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

示例

查找所有投票数小于等于 4的问题
Find all issues with 4 or fewer votes
:
代码块
votes <= 4
Find all issues that have not been updated in the past month (30 days)
查找过去一个月(30天)内没有更新的问题:
代码块
updated <= "-4w 2d"

锚

	IN
	IN

在...之内 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. 运算符用于查找多个指定字段值的问题。多个值之间用逗号分隔, 用括号括起来。

使用 "IN" 运算符相当于多个 EQUALS (=) 表达式, 但是使用起来更方便，更简短。也就是说, 输入 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 OR reporter = "jane" #OR OR reporter = "harry". }}具有同等效果。

Examples

示例

查找报告人是jsmith或jbrown或jjones的所有问题
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
查找所有报告人或经办人是Jack或Jill的所有问题:
代码块
reporter in (Jack,Jill) or assignee in (Jack,Jill)
Find all issues in version 3.14 or version
查找影响版本是3.14 或 4.
2
2的问题:
代码块
affectedVersion in ("3.14", "4.2")

锚

	NOT_IN
	NOT_IN

不在...之内 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运算符相当于多个 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 AND reporter != "jane" #AND AND reporter != "harry". }}具有相同的效果。

Examples

示例

查找所有报告人不是Jack或不是Jill或不是John的问题
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'
查找修复版本不是'A', 'B', 'C'
or
或不是 'D'的问题,
or has not been specified
或者没有指定修复版本值的问题:
代码块
FixVersion not in ( A, B, C, D) or FixVersion is empty

锚

	CONTAINS
	CONTAINS

锚

	~
	~

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

包含页面

	quickstartdoc:__JQL Text Fieldsquickstart
	doc:__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.

Examples

运算符, 在运算符右侧的字段值可以使用 JIRA 文本搜索语法。

示例

查找主题中包括"full screen"词组的问题
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")的问题:
代码块
summary ~ win

锚

	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.运算符用于模糊匹配不包含指定字符的问题。只能用于文本字段, 例如:

包含页面

	quickstartdoc:__JQL Text Fieldsquickstart
	doc:__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.

Examples

运算符, 在运算符右侧的字段值可以使用 JIRA 文本搜索语法。

示例

查找主题中不包括 "run"单词的问题 (或其衍生单词, 比如 "running" 或
Find all issues where the Summary does not contain the word "run" (or derivatives of that word, such as "running" or
"ran"):
代码块
summary !~ run

锚

	IS
	IS

是 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.

Examples

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

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

示例

查找修复版本没有赋值的所有问题
Find all issues that have no Fix Version
:
代码块
fixVersion is empty
or
或
代码块
fixVersion is null

锚

	IS_NOT
	IS_NOT

不是 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.

Examples

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

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

示例

查找所有被投票的问题
Find all issues that have one or more votes
:
代码块
votes is not empty
or
或
代码块
votes is not null

锚

	field
	field

锚

	fields
	fields

...

字段参考

内容区目录

maxLevel	4
minLevel	4
location	top
type	list

锚

	affectedVersion
	affectedVersion

锚

	AffectedVersion
	AffectedVersion

Affected Version

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

信息

title	It 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 which rely on that name. Version IDs, however, are unique and cannot be changed.

Note: this field supports #auto-complete.

Syntax

代码块
affectedVersion

Field Type

VERSION

Supported Operators

影响版本

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

信息

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

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

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

语法

代码块
affectedVersion

字段类型

版本 VERSION

支持的操作符

包含页面

	doc

包含页面

quickstart:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

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.

Supported Functions

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

Examples

使用版本排序只按照JIRA管理员设置的顺序, 而不按照数值或字母顺序。

支持的函数

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

示例

查找影响版本是 3.14的问题
Find issues with an AffectedVersion of 3.14
:
代码块
affectedVersion = "3.14"
(
Note that full-stops are reserved #characters, so they need to be surrounded by quote marks.)
注意点(.)是保留字符, 所以你需要用引号括起来。)
查找影响版本是
Find issues with an AffectedVersion of
"Big Ted"的问题:
代码块
affectedVersion = "Big Ted"
Find
issues with an AffectedVersion ID of 10350
查找影响版本ID是 10350的问题:
代码块
affectedVersion = 10350

锚

	Assignee
	Assignee

Assignee

Search for issues that are assigned to a particular user. You can search by the user's Full Name, ID or Email Address.

Note: this field supports #auto-complete.

Syntax

经办人

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

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

语法

代码块
assignee

Field Type

字段类型

用户 USER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

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

#membersOf()

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

#currentUser()

Examples

支持的函数

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

是...的成员 membersOf()

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

当前用户 currnetUser()

示例

搜索分配给John Smith的问题
Search for issues that are assigned to 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

Field Type

字段类型

类别 CATEGORY

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

搜索属于 "内部项目"类别下的所有问题
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.

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

Syntax

备注

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

可以使用JIRA 文本搜索语法。

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

语法

代码块
comment

Field Type

字段类型

文本 TEXT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Fields (excluding IS)quickstart
	doc:__JQL Operators supported by Text Fields (excluding IS)
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

模糊搜索备注中包含
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\""

锚

	Component
	Component

Component

模块

搜索一个项目中的指定模块的问题。你可以按照模块名称或模块ID (JIRA自动分配给模块的数字)搜索。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).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

代码块
component

Field Type

COMPONENT

Supported Operators

包含页面

quickstart:__JQL Operators supported by Select Fields

	搜索模块ID搜索比搜索模块名称更准确

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

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

语法

代码块
component

字段类型

模块 COMPONENT

支持的运算符

包含页面

	doc:__JQL Operators supported by Select Fields
	doc:__JQL Operators supported by Select Fields
nopanel	true

支持的函数

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

模块负责人 componentsLeadByUser()

示例

查找模块是 "Comp1" 或 "Comp2" 的问题:
代码块
component in (Comp1, Comp2)
查找模块是 "Comp1" 并且也是"Comp2" 的问题

quickstart:__JQL Operators supported by Select Fieldsnopaneltrue

Supported Functions

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

#componentsLeadByUser()

Examples

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

锚

	createdDate
	createdDate

创建日期

Created

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

按照指定的创建日期范围搜索问题。

包含页面

	doc:__JQL Date Formats
	doc

包含页面

quickstart:__JQL Date Formats	quickstart:__JQL Date Formats
nopanel	true

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

Syntax

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

语法

代码块
created

Alias或者:

代码块
createdDate

Field Type

字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

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

Examples

支持的函数

当使用等于, 不等于, 大于, 大于等于, 小于或小于等于运算符时, createdDate 支持:

示例

查找2008年12月12日 00:00之前创建的问题(包括00:00)
Find all issues created on or before 12th December 2008 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.

自定义字段

只有当JIRA管理员已经创建了自定义字段才有效

按照指定自定义字段值查找问题。

你可以按照自定义字段名称或自定义字段ID(JIRA自动为自定义字段分配的数值)搜索。You can search by Custom Field name or Custom Field ID (i.e. the number that JIRA automatically allocates to an Custom Field).

信息

title	It 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.

Syntax

搜索自定义字段ID比搜索自定义字段名称更准确

JIRA中自定义字段名称可能会与系统字段名称相同, 这种情况下，如果按照自定义字段名称搜索，JIRA只会搜索系统个字段，而不搜索自定义字段。一旦JIRA管理员修改了自定义字段名称, 以自定义字段名称为搜索条件的过滤器将无法工作。自定义字段ID是唯一且无法修改的。

注意:

JIRA文本搜索语法可以用于'文本'类型的自定义字段。
自动完成支持选择器类型、用户组选择器类型, 选择列表类型 (不包括 '级联选择类型'), 复选框类型和单选按钮类型的自定义字段。

语法

代码块
CustomFieldName

Alias或者:

代码块
cf[CustomFieldID]

Field Type

Depends on the Custom Field's configuration

Supported Operators

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

字段类型

依赖于自定义字段的配置。

支持的运算符

不同类型的自定义字段支持不同的运算符。对于默认的自定义字段, 支持下面的运算符:

数值和日期/时间类型字段Number and date/time fields:
包含页面
quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
doc:__JQL Operators supported by Numeric Fields
nopanel true
Picker选择器, select, check-box and radio button fields选择列表, 复选框和单选按钮类型字段:
包含页面
quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
doc:__JQL Operators supported by Select Fields
nopanel true
Text fields文本类型字段:
包含页面
quickstartdoc:__JQL Operators supported by Text Fieldsquickstart
doc:__JQL Operators supported by Text Fields
nopanel true

Supported Functions

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

Date/time fields: #currentLogin(), #lastLogin() and #now() (when used with any operator except #IS or #IS NOT)
Version picker fields: #releasedVersions() and #unreleasedVersions() (when used with the #IN and #NOT_IN operators)

Examples

支持的函数

不同类型的自定义字段支持不同的函数。对于默认的自定义字段, 支持下面的函数:

日期/时间类型字段: 当前用户进程 currentLogin(), 当前用户上次进程 lastLogin() 以及当前时间 now() (当使用除了是 (IS) 或不是 (IS NOT)之外的其他运算符时)
版本选择器类型字段: 已发布版本 releasedVersions() 和未发布版本 unreleasedVersions() (当使用在...之内(IN) 和不在...之内 (NOT IN) 运算符时)

示例

查找自定义字段 "Location" 的值为 "New York"的问题
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
查找自定义字段ID 10003的值为"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.

Syntax

描述

搜索描述中包含指定字符的问题。

可以使用JIRA文本搜索语法。

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

语法

代码块
description

Field Type

字段类型

文本 TEXT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Fieldsquickstart
	doc:__JQL Operators supported by Text Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

模糊搜索描述中包含
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). 按照问题的逾期日期范围搜索问题。

包含页面

	quickstartdoc:__JQL Date Formatsquickstart
	doc:__JQL Date Formats
nopanel	true

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

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

Syntax

注意逾期日期只能根据日期计算 (不能根据时间计算)。

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

语法

代码块
due

Alias或者:

代码块
dueDate

Field Type

字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

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

Examples

支持的函数

当使用等于, 不等于, 大于, 大于等于, 小于或小于等于运算符时, dueDate 支持:

示例

搜索截止2009年1月1日逾期的问题
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
查找2009年1月到期的问题:
代码块
due > "2008/12/31" and due < "2009/02/01"
Find issues that were due on 15 January 2009
查找2009年1月15日到期的问题:
代码块
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.

Syntax

环境

搜索环境字段中包含指定字符的问题。

可以使用JIRA文本搜索语法。

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

语法

代码块
environment

Field Type

字段类型

文本 TEXT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Fieldsquickstart
	doc:__JQL Operators supported by Text Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

模糊搜索环境中包括
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

过滤器

你可以直接在JQL中使用保存的过滤器。可以使用过滤器名称或过滤器ID(JIRA自动为过滤器分配的数值)搜索。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).

信息

title	It 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:

搜索过滤器ID 比搜索过滤器名称更精确

一旦修改了过滤器名称, 以过滤器名称为条件的其他过滤器将失效。过滤器 ID是唯一且不能更改的。

注意:

输入的查询语句中的排序 (ORDER BY) 表达式将会代替过滤器中的 ORDER BY 表达式。
你不能执行或保存一个无限循环的过滤器 (例如当一个被引用的过滤器中又引用的当前的过滤器，是无法执行的。)。
这个字段支持自动完成。
语法
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.
Syntax
代码块
filter
Aliases
或者:
代码块
request
代码块
savedFilter
代码块
searchRequest

Field Type

字段类型

过滤器 FILTER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fields (excluding IS)quickstart
	doc:__JQL Operators supported by Select Fields (excluding IS)
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

返回过滤器
Search the results of the filter
"My Saved Filter" (
which has an ID of
过滤器ID是 12000)
for issues assigned to the user jsmith
中经办人是jsmith的问题:
代码块
filter = "My Saved Filter" and assignee = jsmith
or
或
代码块
filter = 12000 and assignee = jsmith

锚

	FixVersion
	FixVersion

锚

	fixVersion
	fixVersion

Fix Version

修复版本

按照指定的修复版本搜索问题。你可以使用版本名称或版本ID (JIRA自动为版本分配的数值)搜索。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).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

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

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

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

语法

代码块
fixVersion

Field Type

字段类型

版本 VERSION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

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.

Supported Functions

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

Examples

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

支持的函数

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

示例

查找修复版本是 3.14 或 4.2的问题
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.)
(注意句号(.)是JIRA保留字符, 所以你需要用引号将其括起来。)
查找修复版本是
Find issues with a Fix Version of
"Little Ted"的问题:
代码块
fixVersion = "Little Ted"
Find issues with
查找修复版本ID 是10001的问题
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.

Syntax

问题键值

按照指定的问题键值或问题ID (JIRA自动为问题分配的数值)。

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

语法

代码块
issueKey

Aliases或者:

代码块
id

代码块
issue

代码块
key

Field Type

字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

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

Examples

支持的函数

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

示例

查找键值是
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).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

代码块
level

Field Type

SECURITY LEVEL

Supported Operators

	Level

安全级别

只有当JIRA管理员开启了问题安全级别时才有效

按照指定的安全级别搜索问题。你可以按照问题安全级别或问题安全级别ID(JIRA自动为问题安全级别分配的数值)搜索。

信息

title	搜索安全级别ID比搜索安全级别名称更准确

一旦JIRA管理员修改了安全级别名称, 以安全级别名称为条件的过滤器将无法工作。安全级别ID是唯一且不能被修改的。

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

语法

代码块
level

字段类型

安全级别 SECURITY LEVEL

支持的运算符

包含页面

	doc

包含页面

quickstart:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

搜索安全级别是
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
搜索安全级别ID 是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).

初始预估时间

只有JIRA管理员开启了时间跟踪才有效

按照初始预估时间的值(只能是数字, 不能是日期或日期范围)搜索问题

使用 Use "w", "d", "h" and 和 "m" to specify weeks来指定周, days, hours or minutes.

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

Syntax

日, 小时或分钟。

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

语法

代码块
originalEstimate

Alias或者:

代码块
timeOriginalEstimate

Field Type

字段类型

期间 DURATION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找初始预估时间为1小时的问题
Find issues with an Original Estimate of 1 hour
:
代码块
originalEstimate = 1h
Find issues with an
Original Estimate of more than 2 days
查找初始预估时间大于2天的问题:
代码块
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.

Syntax

父问题

只有当JIRA管理员开启子任务(连接到Atlassian网站) 才有效

搜索指定问题的所有子任务。你可以按照问题键值或问题ID (JIRA自动为问题分配的数值)搜索。

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

语法

代码块
parent

Field Type

字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fields (excluding IS)quickstart
	doc:__JQL Operators supported by Select Fields (excluding IS)
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

搜索问题
Find issues that are sub-tasks of issue
TEST-
1234
1234的所有子任务:
代码块
parent = TEST-1234

Priority

锚

	Priority

Priority

	Priority

优先级

按照指定的优先级搜索问题。你可以使用优先级名称或优先级ID (JIRA自动为优先级分配的数值)搜索。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).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

搜索优先级ID比搜索优先级名称更准确

一旦JIRA管理员修改了优先级名称, 以优先级名称为搜索条件的过滤器将无法工作。优先级ID是唯一且无法更改的。

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

语法

代码块
priority

Field Type

字段类型

优先级 PRIORITY

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

搜索优先级时
Find issues with a Priority of
"High"的问题:
代码块
priority = High
Find issues with
a Priority ID of 10000
搜索优先级ID是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).

Note: this field supports #auto-complete.

Syntax

项目

搜索指定项目中的问题。

你可以按照项目名称, 或项目键值或项目ID (JIRA自动为项目分配的数值)搜索。

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

语法

代码块
project

Field Type

字段类型

项目 PROJECT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

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

Examples

支持的函数

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

示例

查找项目名称是 "ABC Project"的问题
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
查找项目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).

剩余预估时间

只有JIRA管理员开启了时间跟踪才有效

按照剩余预估时间的值(只能是数字, 不能是日期或日期范围)搜索问题

使用 Use "w", "d", "h" and 和 "m" to specify weeks来指定周, days, hours or minutes.

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

Syntax

日, 小时或分钟。

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

语法

代码块
remainingEstimate

Alias或者:

代码块
timeEstimate

Field Type

字段类型

期间 DURATION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找剩余预估时间大于4小时的问题
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.

Note: this field supports #auto-complete.

Syntax

报告人

按照指定的报告人(创建人)搜索问题。

你可以按照用户全称、ID或邮件地址搜索。

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

语法

代码块
reporter

Field Type

字段类型

用户 USER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

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

#membersOf()

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

#currentUser()

Examples

支持的函数

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

是...的成员 membersOf()

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

当前用户 currentUser()

示例

搜索由Jill Johns创建的问题
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.)
注意句号(.)和 "@" 符号是JIRA保留字符, 所以你需要用引号将其括起来。)

锚

	Resolution
	Resolution

Resolution

Search for issues that have a particular Resolution

解决结果

按照指定的解决结果搜索问题。

你可以将解决结果的名称和ID(JIRA自动为解决结果分配的数值)作为搜索条件。You can search by Resolution name or Resolution ID (i.e. the number that JIRA automatically allocates to a Resolution).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

搜索解决结果ID比搜索解决结果名称更准确

一旦JIRA管理员更改了解决结果的名称, 以解决结果名称为条件的过滤器将无法工作。而解决结果ID是唯一且不能修改的。

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

语法

代码块
resolution

Field Type

字段类型

解决结果 RESOLUTION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找解决方法为
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
查找解决方法ID为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).

包含页面

	quickstartdoc:__JQL Date Formatsquickstart
	doc:__JQL Date Formats
nopanel	true

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

Syntax

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

语法

代码块
resolved

Alias或者:

代码块
resolutionDate

Field Type

字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

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

Examples

示例

查找2008年12月31日00:00之前解决的问题
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
查找2009年1月解决的问题:
代码块
resolved > "2008/12/31" and resolved < "2009/02/01"
Find issues that were resolved on 15 January 2009
查找2009年1月15日解决的问题:
代码块
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.


	Status

状态

按照指定的状态查找问题。

你可以按照状态名称或状态ID(JIRA自动为状态分配的数值)搜索问题。You can search by Status name or Status ID (i.e. the number that JIRA automatically allocates to a Status).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

搜索状态ID比搜索状态名称更准确

一旦JIRA管理员更改了状态名称，按照状态名称为搜索条件的过滤器将无法工作。状态ID是唯一且无法更改的。

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

语法

代码块
status

Field Type

字段类型

状态 STATUS

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找状态是
Find issues with a Status of
"Open"的问题:
代码块
status = Open
Find issues with a Status ID
of 1
查找状态ID 是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.

Syntax

主题

按照主题中指定的字符查找问题。

可以使用JIRA 文本搜索语法。

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

语法

代码块
summary

Field Type

字段类型

文本 TEXT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Fieldsquickstart
	doc:__JQL Operators supported by Text Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

模糊查找主题中包含
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

	Text

文本

可以在以下文本字段内容中查找包含指定字符的问题This is a "master-field" that allows you to search all text fields, i.e.:

包含页面

	quickstartdoc:__JQL Text Fieldsquickstart
	doc:__JQL Text Fields
nopanel	true

Note注意: The text master-field can only be used with the #CONTAINS operator text 只能和包含运算符 ("~" and 以及 "!~"). 结合使用。

Syntax

语法

代码块
text

Field Type

字段类型

文本 TEXT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Fields (excluding IS and NOT)quickstart
	doc:__JQL Operators supported by Text Fields (excluding IS and NOT)
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找文本字段中包括
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.

问题类型

按照指定的问题类型搜索问题

你可以按照问题类型名称或问题类型ID (JIRA自动为问题类型分配的数值)搜索问题。You can search by Issue Type name or Issue Type ID (i.e. the number that JIRA automatically allocates to an Issue Type).

信息

title	It 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.

Note: this field supports #auto-complete.

Syntax

搜索问题类型ID比搜索问题类型名称更准确

一旦JIRA管理员修改了问题类型名称，以问题类型名称为搜索条件的过滤器将无法工作。问题类型ID是唯一且不能修改的。

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

语法

代码块
type

Alias或者:

代码块
issueType

Field Type

字段类型

问题类型 ISSUE_TYPE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找问题类型是
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
查找问题类型ID是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).

实际工作时间

只有当JIRA管理员开启了时间跟踪(链接到)才有效

按照实际工作时间的值 (只能是数字，不能是日期或日期范围)搜索问题。

使用 Use "w", "d", "h" and 和 "m" to specify weeks来指定周, days, hours or minutes.

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

Syntax

日, 小时或分钟。

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

语法

代码块
timeSpent

Field Type

字段类型

期间 DURATION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找实际工作时间大于5天的问题
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).

包含页面

	quickstartdoc:__JQL Date Formatsquickstart
	doc:__JQL Date Formats
nopanel	true

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

Syntax

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

语法

代码块
updated

Alias或者:

代码块
updatedDate

Field Type

字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

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

Examples

示例

查找2008年12月12日00:00之前更新的问题
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
查找2周之前更新的问题:
代码块
updated < "-2w"
Find issues that were updated on 15 January 2009
查找2009年1月15日更新的问题:
代码块
updated > "2009/01/14" and updated < "2009/01/16"
Find issues that were updated in January 2009
查找2009年1月更新的问题:
代码块
updated > "2008/12/31" and updated < "2009/02/01"

锚

/12/31" and updated < "2009/02/01"

锚

	voter
	voter

锚

	Voter
	Voter

投票人

按照指定的投票人查找问题。你可以按照用户全名、ID 或电子邮件地址搜索。需要注意的是，你必须拥有 "查看投票人及关注者"权限才能根据投票人搜索问题, 否则你只能搜索你自己投票的问题。具体内容参见投票的问题。

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

语法

代码块
voter

字段类型

USER

支持的运算符

包含页面

	doc

votervoter 锚VoterVoter

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.

Note: this field supports #auto-complete.

Syntax

代码块
voter

Field Type

USER

Supported Operators

包含页面

quickstart:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

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

#membersOf()

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

#currentUser()

Examples

支持的函数

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

是...的成员 membersOf()

当使用等于以及不等于运算符时, voter 支持:

当前用户 currentUser()

示例

搜索你自己投票的问题
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.

Syntax

投票数量

搜索指定投票数量的问题。

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

语法

代码块
votes

Field Type

字段类型

NUMBER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fields (excluding IS)quickstart
	doc:__JQL Operators supported by Numeric Fields (excluding IS)
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找投票数大于等于12的问题
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.

Note: this field supports #auto-complete.

Syntax

关注人

按照指定关注人搜索问题。你可以按照用户全称、ID或电子邮件地址搜索。需要注意的是，你必须拥有 "查看投票人及关注者"权限才能根据关注人搜索问题, 否则你只能搜索你自己关注的问题。具体信息请参阅关注的问题。

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

语法

代码块
voter

Field Type

字段类型

USER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Select Fieldsquickstart
	doc:__JQL Operators supported by Select Fields
nopanel	true

Supported Functions

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

#membersOf()

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

#currentUser()

Examples

支持的函数

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

是...的成员 membersOf()

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

当前用户 currentUser()

示例

搜索你关注的问题
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.

工作时间比率

只有当JIRA管理员开启了时间跟踪(链接到)才有效

按照指定的工作时间比率的值搜索问题。

工作时间比率的计算公式是: 工作时间比率 = 实际工作时间 / 初始预估时间Work Ratio is calculated as follows: workRatio = #timeSpent / #originalEstimate) x 100

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

Syntax

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

语法

代码块
workRatio

Field Type

字段类型

数值 NUMBER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Numeric Fieldsquickstart
	doc:__JQL Operators supported by Numeric Fields
nopanel	true

Supported Functions

支持的函数

n/a

Examples

示例

查找实际工作时间占初始预估时间百分比大于75%的问题
Find issues on which more than 75% of the Original Estimate has been spent
:
代码块
workRatio > 75

锚

	function
	function

锚

	functions
	functions

...

函数参考

查看具体的 权限 参数

支持的字段类型

项目 PROJECT

支持的运算符

内容区目录

maxLevel	4
minLevel	4
location	top
type	list

锚

	cascadeOption
	cascadeOption

cascadeOption()

Search for issues that match the selected values of a 'cascading select' custom field.

The parentOption parameter matches against the first tier of options in the cascading select field. The childOption parameter matches against the second tier of options in the cascading select field, and is optional.

The keyword "none" can be used to search for issues where either or both of the options have no value.

Syntax

级联选择列表值 cascadeOption()

按照自定义字段中设置的 '级联选择列表'值来查找问题。

一级列表值 是必选参数。 二级列表值 是可选参数。

关键字 "none" 可以用来搜索级联列表值为空的问题。

语法

代码块
cascadeOption(parentOption)

or 或者

代码块
cascadeOption(parentOption,childOption)

Supported Field Types

支持的字段类型

级联选择列表 CASCADING_OPTION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找自定义字段
Find issues where a custom field
("Location")
has the value
中 "USA"
for the first tier and
下 "New York"
for the second tier
的问题:
代码块
location in cascadeOption("USA","New York")
Find issues where a custom field
查找自定义字段 ("Location")
has the value
中 "USA"
for the first tier and any value (or no value) for the second tier
下(包括二级选择值为空)的所有问题:
代码块
location in cascadeOption("USA")
Find issues where a custom field
查找自定义字段 ("Location")
has the value
中 "USA"
for the first tier and no value for the second tier
下, 二级选择值为空的问题:
代码块
location in cascadeOption("USA",none)
Find issues where a custom field
查找自定义字段 ("Location")
has no value for the first tier and no value for the second tier
中一、二级列表都没有值的问题:
代码块
location in cascadeOption(none)
Find issues where a custom field
查找自定义字段 ("Referrer")
has the value
中一、二级列表值都为"none"
for the first tier and "none" for the second tier
的问题:
代码块
referrer in cascadeOption("\"none\"","\"none\"")
Find issues where a custom field
查找自定义字段 ("Referrer")
has the value
中一级列表值为"none"
for the first tier and no value for the second tier
，二级列表值为空的的问题:
代码块
referrer in cascadeOption("\"none\"",none)

锚

	componentsLeadByUser
	componentsLeadByUser

模块负责人 componentsLeadByUser()

Find issues in components that are lead by a specific user.

You can optionally specify a user, or if the user is omitted the current user (i.e. you) will be used.

Note that if you are not logged in to JIRA, a user must be specified.

Syntax

查找指定模块负责人负责的问题。

如果你没有输入用户参数, JIRA会将当前用户(你)作为默认条件。

如果你没有登录JIRA, 必须指定用户。

语法

代码块
componentsLeadByUser()

or 或

代码块
componentsLeadByUser(username)

Supported Field Types

支持的字段类型

模块 COMPONENT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查看模块负责人是你，状态是Open的问题
Find open issues in components that are lead by you
:
代码块
component in componentsLeadByUser() AND status = Open
Find open issues in components that are lead by Bill
查看模块负责人是Bill，状态是Open的问题:
代码块
component in componentsLeadByUser(bill) AND status = Open

锚

	currentLogin
	currentLogin

当前用户进程 currentLogin()

Perform searches based on the time at which the current user's session began. See also #lastLogin.

Syntax

按照当前用户进程搜索问题。还可以查阅上次进程。

语法

代码块
currentLogin()

Supported Field Types

支持的字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Date Functionsquickstart
	doc:__JQL Operators supported by Date Functions
nopanel	true

Examples

示例

查找当前进程中创建的问题
Find issues that have been created during my current session
:
代码块
created > currentLogin()

锚

	currentUser
	currentUser

当前用户 currentUser()

Perform searches based on the currently logged-in user.

Note that this function can only be used by logged-in users. So if you are creating a saved filter that you expect to be used by anonymous users, do not use this function.

Syntax

按照当前用户查找问题。

只有登录用户才能使用这个函数。所以匿名用户创建的过滤器无法使用这个函数。

语法

代码块
currentUser()

Supported Field Types

支持的字段类型

用户 USER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by User Functionsquickstart
	doc:__JQL Operators supported by User Functions
nopanel	true

Examples

示例

查找分配给我的问题
Find issues that are assigned to me
:
代码块
assignee = currentUser()
Find issues that were reported to me but are not assigned to me
查找我报告的但不是分配给我的问题:
代码块
reporter = currentUser() and assignee != currentUser()

锚

	issueHistory
	issueHistory

最近查看的问题 issueHistory()

Find issues that you have recently viewed, i.e. issues that are in the 'Recent Issues' section of the 'Issues' drop-down menu.

查看你最近查看的问题, 就是在页面顶部菜单导航栏 '问题'菜单下的'最近查看的问题'中的问题。

注意Note:

issueHistory() returns up to 50 issues, whereas the 'Recent Issues' drop-down returns only 5.
if you are not logged in to JIRA, only issues from your current browser session will be included.

Syntax

只返回50个结果, 但是 '最近查看的问题' 只返回5个结果。
如果你没有登录JIRA, 只返回当前浏览器进程中浏览的问题。

语法

代码块
issueHistory()

Supported Field Types

支持的字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找我最近查看的，并且分配给我的问题
Find issues which I have recently viewed, that are assigned to me
:
代码块
issue in issueHistory() AND assignee = currentUser()

锚
lastLogin	lastLogin

lastLogin()

Perform searches based on the time at which the current user's previous session began. See also #currentLogin.

Syntax

	lastLogin
	lastLogin

用户上次进程 lastLogin()

按照当前用户上次进程搜索问题。还可以查阅当前进程。

语法

代码块
currentLogin()

Supported Field Types

支持的字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Date Functionsquickstart
	doc:__JQL Operators supported by Date Functions
nopanel	true

Examples

示例

查找上次进程中创建的问题
Find issues that have been created during my last session
:
代码块
created > lastLogin()

锚

	linkedIssues
	linkedIssues

链接的问题 linkedIssues()

Perform searches based on issues which are linked to a specified issue.

You can optionally restrict the search to links of a particular type. Note that LinkType is case-sensitive.

Syntax

查找问题的链接作为条件查找问题。

你可以指定链接类型作为查询条件，注意链接类型大小写敏感。

语法

代码块
linkedIssues(issueKey)

or 或者

代码块
linkedIssues(issueKey,linkType)

Supported Field Types

支持的字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找被ABC-123链接的问题
Find issues that are linked to a particular issue
:
代码块
issue in linkedIssues(ABC-123)
Find issues that are linked to a particular issue via a particular type of link
查找被ABC-123链接，链接类型是"重复"的问题:
代码块
issue in linkedIssues(ABC-123,"is duplicated by重复")

锚

	membersOf
	membersOf

是...的成员 membersOf()

Perform searches based on the members of a particular group.

Syntax

按照指定用户组成员来查找问题。

语法

代码块
membersOf(Group)

Supported Field Types

支持的字段类型

用户 USER

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找分配人是用户组
Find issues where the Assignee is a member of the group
"jira-developers"的问题:
代码块
assignee in membersOf("jira-developers")

Search through multiple groups and a specific user, e.g

搜索多个用户组成员报告的问题:

代码块
reporter in membersOf("jira-developers") or reporter in membersOf("jira-administrators") or reporter=jsmith

Search for a particular group, but exclude a particular member or members, e.g.
搜索用户在指定用户组并且不再另外用户组中的问题:
代码块
assignee in membersOf(QA) and assignee not in ("John Smith","Jill Jones")
经办人不是用户组QA成员的问题
Exclude members of a particular group
:
代码块
assignee not in membersOf(QA)

锚

	now
	now

当前时间 now()

Perform searches based on the current time.

Syntax

以当前时间为搜索条件。

语法

代码块
now()

Supported Field Types

支持的字段类型

日期 DATE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Date Functionsquickstart
	doc:__JQL Operators supported by Date Functions
nopanel	true

Examples

示例

查找过期的未解决的问题

Find issues that are overdue

:

代码块
duedate < now() and status not in (closed, resolved)

锚

	projectsLeadByUser
	projectsLeadByUser

项目负责人 projectsLeadByUser()

Find issues in projects that are lead by a specific user.

You can optionally specify a user, or if the user is omitted the current user will be used.

Note that if you are not logged in to JIRA, a user must be specified.

Syntax

查找指定项目负责人负责的问题。

你可以指定一个用户，或者不指定用户，JIRA会自动按照当前用户查找。

如果你没有登录JIRA, 你必须指定一个用户来执行这个函数。

语法

代码块
projectsLeadByUser()

or 或者

代码块
projectsLeadByUser(username)

Supported Field Types

支持的字段类型

项目 PROJECT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找项目负责人是你的问题
Find open issues in projects that are lead by you
:
代码块
project in projectsLeadByUser() AND status = Open
Find open issues in projects that are lead by Bill
查找项目负责人是Bill，并且状态为Open的问题:
代码块
project in projectsLeadByUser(bill) AND status = Open

锚

	projectsWhereUserHasPermission
	projectsWhereUserHasPermission

你拥有的项目权限 projectsWhereUserHasPermission()

Find issues in projects where you have a specific permission.

Note that this function is only available if you are logged in to JIRA.

Syntax

按照你拥有的项目权限查找问题。

只有登录到JIRA后才能使用这个函数。

语法

代码块
projectsWhereUserHasPermission(permission)

For the permission parameter you can specify any of the following:

包含页面

quickstart:__project permissions quickstart:__project permissions

nopanel true

包含页面

	doc

Supported Field Types

PROJECT

Supported Operators

包含页面

quickstart:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找你拥有
Find open issues in projects where you have the
"Resolve Issues"权限的项目中，状态"Open"
permission
的问题:
代码块
project in projectsWhereUserHasPermission("Resolve Issues") AND status = Open

锚

	projectsWhereUserHasRole
	projectsWhereUserHasRole

你属于的项目角色 projectsWhereUserHasRole()

Find issues in projects where you have a specific role.

Note that this function is only available if you are logged in to JIRA.

Syntax

按照你属于指定的项目角色搜索问题。

注意只有登录JIRA后才能使用这个函数。

语法

代码块
projectsWhereUserHasRole(rolename)

Supported Field Types

支持的字段类型

项目 PROJECT

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找你作为
Find open issues in projects where you have the
"Developers"
role
角色的项目中状态为"Open"的问题:
代码块
project in projectsWhereUserHasRole("Developers") AND status = Open

锚

	releasedVersions
	releasedVersions

已发布版本 releasedVersions()

Perform searches based on the released versions (i.e. versions that your JIRA administrator has released) of a specified project.

You can also search on the released versions of all projects, by omitting the project parameter.

Syntax

查找指定项目中已发布版本的问题。

如果没有输入项目参数，就会搜索所有项目的已发布版本的问题。

语法

代码块
releasedVersions()

or 或

代码块
releasedVersions(project)

Supported Field Types

支持的字段类型

版本 VERSION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找项目 ABC 中所有修复版本(FixVersion)#FixVersion 已经发布的问题
Find issues whose #FixVersion is a released version of the ABC project
:
代码块
fixVersion in releasedVersions(ABC)
Find issues that relate to released versions of the ABC project
查找项目 ABC 中所有影响版本和修复版本已经发布的问题 :
代码块
affectedVersion in releasedVersions(ABC)
or
或
代码块
fixVersion in releasedVersions(ABC)

锚

	standardIssuesTypes
	standardIssuesTypes

标准问题类型 standardIssueTypes()

Perform searches based on "standard" Issue Types, that is, search for issues which are not sub-tasks.

Syntax

按照"标准" 问题类型查找问题。标准问题类型指的是非子任务的问题。

语法

代码块
standardIssueTypes()

Supported Field Types

支持的字段类型

问题类型 ISSUE_TYPE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找非子任务类型的问题 (标准问题类型的问题，不是子任务问题类型
Find issues that are not subtasks (i.e. issues whose Issue Type is a standard issue type, not a subtask issue type
):
代码块
issuetype in standardIssueTypes()

锚

	subtaskIssuesTypes
	subtaskIssuesTypes

子任务问题类型 subtaskIssueTypes()

Perform searches based on issues which are sub-tasks.

Syntax

查找所有子任务问题。

语法

代码块
subtaskIssueTypes()

Supported Field Types

支持的字段类型

问题类型 ISSUE_TYPE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找所有子任务问题 (问题类型是子任务类型
Find issues that are subtasks (i.e. issues whose Issue Type is a subtask issue type
):
代码块
issuetype in subtaskIssueTypes()

锚

	unreleasedVersions
	unreleasedVersions

未发布版本 unreleasedVersions()

Perform searches based on the unreleased versions (i.e. versions that your JIRA administrator has not yet released) of a specified project.

You can also search on the unreleased versions of all projects, by omitting the project parameter.

Syntax

查找指定项目中未发布版本的问题。

如果没有输入项目参数，就会搜索所有项目的已发布版本的问题。

语法

代码块
unreleasedVersions()

or 或

代码块
unreleasedVersions(project)

Supported Field Types

支持的字段类型

版本 VERSION

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找ABC项目中修复版本(FixVersion)还未发布的问题
Find issues whose #FixVersion is an unreleased version of the ABC project
:
代码块
fixVersion in unreleasedVersions(ABC)
Find issues that relate to unreleased versions of the ABC project
查找ABC项目中影响版本和修复版本尚未发布的问题:
代码块
affectedVersion in unreleasedVersions(ABC)
or
代码块
fixVersion in unreleasedVersions(ABC)

锚

	votedIssues
	votedIssues

投票的问题 votedIssues()

Perform searches based on issues for which you have voted. Also see the #Voter field.

Note that this function can only be used by logged-in users.

Syntax

查看你已投票的问题。请查阅投票人(Voter)字段。

只有登录用户才能使用这个函数。

语法

代码块
votedIssues()

Supported Field Types

支持的字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找你投票的问题
Find issues that you have voted for
:
代码块
issue in votedIssues()

锚

	watchedIssues
	watchedIssues

关注的问题 watchedIssues

()

查找你正在关注的问题。请查看关注人(Watcher)字段。

只有登录用户才能使用这个函数。

语法

watchedIssues()

Perform searches based on issues which you are watching. Also see the #Watcher field.

Note that this function can only be used by logged-in users.

Syntax

代码块
watchedIssues()

Supported Field Types

支持的字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

示例

查找你关注的问题
Find issues that you are watching
:
代码块
issue in watchedIssues()

Supported Field Types

支持的字段类型

问题 ISSUE

Supported Operators

支持的运算符

包含页面

	quickstartdoc:__JQL Operators supported by Text Functionsquickstart
	doc:__JQL Operators supported by Text Functions
nopanel	true

Examples

Find issues that you have recently viewed:
代码块
issue in issueHistory()

...

示例

查找最近刚刚查看过的问题:
代码块
issue in issueHistory()

锚

	parentheses
	parentheses

控制运算顺序

你可以在复杂的JQL语句中使用括号来控制运算符的运算顺序。

例如, 如果你想查找SysAdmin项目中所有问题解决的问题，或者分配给系统管理员(bobsmith)的问题, 你可以使用括号来控制运算顺序, 例如

...

Setting Precedence of Operators

You can use parentheses in complex JQL statements to enforce the precedence of #operators.

For example, if you want to find all resolved issues in the SysAdmin project as well as all issues (any status, any project) currently assigned to the system administrator (bobsmith), you can use parentheses to enforce the precedence of the boolean operators in your query, i.e.:

代码块
(status=resolved AND project=SysAdmin) OR assignee=bobsmith

Note that if you do not use parentheses, the statement will be evaluated left-to-right.

如果你不使用括号, 表达式运算顺序将从左到右逐一运算。

你也可以使用括号将表达式分组, 方便地在表达式前使用否定(NOT)运算符,否定整个表达式的结果。You can also use parentheses to group clauses, so that you can apply the #NOT operator to the group.

锚

	text
	text

Performing Text Searches

You can use Lucene's text-searching features when performing searches on the following fields, using the #CONTAINS operator:

For details, please see the page on Performing Text Searches, which includes the following sections:

...

执行文本搜索

当搜索下面的文本字段时，你可以在查询表达式中使用包括这样的 Lucene 文本搜索特性运算符:

更多详细说明, 请查看搜索文本页面, 该页面包括以下章节:

锚

	auto-complete
	auto-complete

使用自动完成

当你输入以下条件的查询语句时, JIRA 会自动根据上下文提供一些建议

...

Using Auto-complete

As you type your query, JIRA will recognise the context and offer a list of "auto-complete" suggestions as follows:

内容区目录

location	top
type	list

The list of auto-complete suggestions is displayed alphabetically and includes the first 15 matches. Note that auto-complete suggestions are not offered for #function parameters. 建议列表按照字母顺序提供最多15个可选项。JIRA不会提供函数参数的自动完成建议列表。

信息

title	Please note:

If no auto-complete suggestions are offered, your administrator may have disabled the "JQL Auto-complete" feature for your JIRA instance.
If you prefer not to be offered auto-complete suggestions, click the "Turn off auto-complete" link below the "#Query" box.

Auto-complete suggestions are not offered for all fields. Check the #fields reference to see which fields support auto-complete.

If you type a space at the start of your query

如果没有可提供的自动完成建议, 管理员可能禁止了 "JQL自动完成" 功能。
如果你不希望使用自动完成建议功能, 点击查询框下方的 "关闭自动完成" 链接。

不是所有字段都提供自动完成建议列表。点击字段参考查看哪些字段支持自动完成。

如果你在查询语句的起始输入了空格...

...JIRA will offer a list of all available fields, e.g.会自动提供所有可用字段的列表, 例如:

If you type one or more characters

如果你输入了超过1个字符...

...JIRA will offer a list of matching fields, e.g.会列出可能匹配的字段列表, 例如:

If you type a field then a space

如果你输入了一个字段并输入了空格...

...JIRA will offer a list of valid #operators, e.g.会列出可用的运算符列表, 例如:

If you type a field, then an operator, then a space

如果你输入了一个字段, 接着输入了一个运算符, 然后又输入了一个空格...

...JIRA will offer a list of valid values, e.g.会提供有效的字段值列表, 例如:

If you type a field, then an operator, then one or more characters

如果你输入了一个字段, 接着输入了一个运算符, 然后又输入了1个字符...

...JIRA will offer a list of valid values (if your #field supports this) and 会提供可用字段值的列表 (如果你输入的字段值支持列表) 以及可用的and valid functions for the field/operator combination, e.g.:

锚

	switching
	switching

...

在 '

...

高级搜索'

...

和 '

...

简单搜索'

...

模式之间切换

In general, a query created using 'Simple Search' will be able to be translated to 'Advanced Search' (i.e. JQL), and back again.

However, a query created using 'Advanced Search' may not be able to be translated to 'Simple Search', particular if:

一般情况下, 使用'简单搜索' 模式的查询条件都可以翻译为 '高级搜索(JQL)'查询条件, 也可以反向翻译。

然而, 使用'高级搜索' 创建的查询条件不一定能够翻译成 '简单搜索'的查询条件, 特别是:

查询语句中包括或者(OR) 运算符 (但是在...之内(IN)运算符可以被翻译成简单模式查询条件, 如 the query contains an OR operator (note you can have an IN operator and it will be translated, e.g. project in (A, B))
- i.e. even though this query虽然这个查询语句: (project = JRA OR project = CONF) is equivalent to this query 与这个查询语句:(project in (JRA, CONF)), only the second query will be translated.
the query contains a NOT operator
the query contains an EMPTY operator
- 一样, 但是只有第二个查询语句才能被翻译成简单搜索语句。
查询语句中包含 NOT 运算符
查询语句中包含 EMPTY 运算符
查询语句中包括比较运算符the query contains any of the comparison operators: !=, IS, IS NOT, >, >=, <, <=
查询语句中指定了与项目有密切关系的字段和字段值 (例如版本, 模块, 自定义字段)，但是又没有在查询条件中明确地指定项目 (例如，只输入了the query specifies a field and value that is related to a project (e.g. version, component, custom fields) and the project is not explicitly included in the query (e.g.
fixVersion = "4.0", without the 而没有输入 AND project=JRA). This is especially tricky with custom fields since they can be configured on a Project/Issue Type basis. The general rule of thumb is
that if the query cannot be created in the 'Simple Search' form, then if it is created using 'Advanced Search' it will not be able to be translated to 'Simple Search'.

...

, 尤其是设置了项目/问题类型的自定义字段。
查询语句翻译的标准规则是：
如果查询语句无法在 '简单搜索' 模式中设置, 而需要在 '高级搜索' 模式中输入的查询语句，是无法翻译为'简单搜索' 查询条件的。

锚

	characters
	characters

保留的字符

JQL保留了一些特定字符。如果你需要在查询语句中使用下面的字符，你必须用引号将其括起来

...

Reserved Characters

JQL has a list of reserved characters. These characters need to be surrounded by quote-marks if you wish to use them in queries:

space (" ")
"+"
"."
","
";"
"?"
"|"
"'"
"*"
"/"
"%"
"^"
"$"
"#"
"@"

信息
You can use either single quote-marks 你既可以使用单引号 (`'`) or double quote-marks 也可以使用双引号 (`"`).

If your search term contains a quote-mark, you will need to precede it with the escape character (back-slash), e.g.如果搜索条件中包含引号, 你需要在引号前加上转义符(反斜线), 例如:

代码块
"Type your name in the \"Login\" box"

If you use a single quote to escape your search term, then you can use the double quote (without escaping it) inside the single quotes; but you will have to escape any other single quotes. And vice-versa.

如果你的搜索条件中包含单引号, 那么你就可以在单引号里面使用双引号(不需要转义符); 但是你必须为其他单引号添加转义符，反之亦然。

注意有一些附加的文本搜索保留字符在以下字段中应用Note that there is an additional list of reserved characters for Text Searches, which applies to the following fields:

包含页面

	quickstartdoc:__JQL Text Fieldsquickstart
	doc:__JQL Text Fields
nopanel	true

.

锚

	words
	words

Reserved Words

保留的单词

JQL保留了一些专用的单词. 如果你需要在查询语句中使用下面的单词，必须用引号将其括起来JQL has a list of reserved words. These words need to be surrounded by quote-marks if you wish to use them in queries:

"abort", "access", "add", "after", "alias", "all", "alter", "and", "any", "as", "asc",
"audit", "avg", "before", "begin", "between", "boolean", "break", "by", "byte", "catch", "cf",
"char", "character", "check", "checkpoint", "collate", "collation", "column", "commit", "connect", "continue",
"count", "create", "current", "date", "decimal", "declare", "decrement", "default", "defaults", "define", "delete",
"delimiter", "desc", "difference", "distinct", "divide", "do", "double", "drop", "else", "empty", "encoding",
"end", "equals", "escape", "exclusive", "exec", "execute", "exists", "explain", "false", "fetch", "file", "field",
"first", "float", "for", "from", "function", "go", "goto", "grant", "greater", "group", "having",
"identified", "if", "immediate", "in", "increment", "index", "initial", "inner", "inout", "input", "insert",
"int", "integer", "intersect", "intersection", "into", "is", "isempty", "isnull", "join", "last", "left",
"less", "like", "limit", "lock", "long", "max", "min", "minus", "mode", "modify",
"modulo", "more", "multiply", "next", "noaudit", "not", "notin", "nowait", "null", "number", "object",
"of", "on", "option", "or", "order", "outer", "output", "power", "previous", "prior", "privileges",
"public", "raise", "raw", "remainder", "rename", "resource", "return", "returns", "revoke", "right", "row",
"rowid", "rownum", "rows", "select", "session", "set", "share", "size", "sqrt", "start", "strict",
"string", "subtract", "sum", "synonym", "table", "then", "to", "trans", "transaction", "trigger", "true",
"uid", "union", "unique", "update", "user", "validate", "values", "view", "when", "whenever", "where",
"while", "with"

信息
You can use either single quote-marks 你既可以使用单引号 (`'`) or double quote-marks 也可以使用双引号 (`"`).

(Note for JIRA administrators: this list is hard coded in the JIRA管理员请注意: 上面列表是 JqlStringSupportImpl.java file.) 文件的固定编码。)

注意还有一些其他文本搜索的保留字段在下面的字段中应用Note that there is an additional list of reserved words for Text Searches, which applies to the following fields:

包含页面

	quickstartdoc:__JQL Text Fieldsquickstart
	doc:__JQL Text Fields
nopanel	true

.

页面树结构

页面历史记录

版本比较

旧版本 1

新版本 当前版本

标识

What is an Advanced Search?

什么是高级搜索?

How to Perform an Advanced Search

如何使用高级搜索

关键字

与 AND

Examples

示例

或 OR

Examples

示例

非 NOT

Examples

示例

EMPTY

Examples

空 EMPTY

示例

NULL

Examples

空 NULL

示例

排序 ORDER BY

Examples

示例

运算符参考

等于: =

Examples

示例

不等于: !=

Examples

示例

大于: >

Examples

示例

大于等于: >=

Examples

示例

小于: <

Examples

示例

小于等于: <=

Examples

示例

在...之内 IN

Examples

示例

不在...之内 NOT IN

Examples

示例

包含: ~

Examples

示例

不包括: !~

Examples

示例

是 IS

Examples

示例

不是 IS NOT

Examples

示例

字段参考

Affected Version

Syntax

Field Type

Supported Operators

影响版本

语法

字段类型

支持的操作符

Supported Functions

Examples

支持的函数

新版本当前版本