本页面的内容:
通过高级搜索,你可以使用结构化查询语言搜索JIRA的问题。 搜索的结果会显示在 问题导航器中, 然后你可以将搜索结果输出为 MS Excel格式 以及 其他格式。 你还可以 保存 以及 订阅搜索结果。
查询语句由一个 字段, 运算符, 和 值 或 _函数_构成。 例如, 下面的查询语句将返回 "TEST"项目的所有问题:
project = "TEST" |
(这个例子使用了 项目(project) 字段, 等于 符号, 和 值 "TEST"
。)
注意不能比较两个 字段。
当你执行高级搜索时, 你使用的是JIRA查询语言(JQL)。 JQL类似SQL表达式, 比如 #> 和 #NULL。 当然, 你不能使用数据库查询语言; 例如, JQL不能使用 SELECT
表达式。
与 AND用于整合多个查询条件, 允许你精炼查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 示例
或 OR用户整合多个查询条件, 允许你扩展查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 (注意: 也可以查看 在...之中(IN)章节, 使用更方便的方法搜索多个字段的值。) 示例
非 NOT用于否定一个运算符或整个查询条件, 允许你优化查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 (注意: 也可以查看 不等于 ("!="), 不包括 ("!~"), 不再...之中 和 不是章节) 示例
空 EMPTY用于搜索没有值的字段。 也可以查看空(NULL)。 注意 EMPTY 只能与 是(IS) 和 不是(IS NOT) 运算符结合使用。 要查看字段支持的运算符, 点击 #字段 。 示例
空 NULL用于搜索字段没有赋值的问题。 请查看 空(EMPTY)。 注意 NULL 只能用于支持 是(IS) 和 不是(IS NOT) 操作符的字段。 要了解字段支持哪些操作符, 请查看每个 字段 参考。 示例
排序 ORDER BY用于对输出的结果,按照指定的字段排序。 默认情况下, 按照字段输出顺序排序。 你可以指定按照升序 (" 示例
|
等于: = " 要精确匹配多个字段值,请使用与(AND)将多个 " 示例
不等于: != " 注意输入 示例
大于: > " 注意 " 示例
大于等于: >= " 注意 " 示例
小于: <The " 注意" 示例
小于等于: <=The " 注意 " 示例
在...之内 IN " 使用 " 示例
不在...之内 NOT IN " 使用 " 示例
包含: ~ " 注意: 使用 " 示例
不包括: !~ " 注意: 使用 " 示例
是 IS " 注意不是所有的 字段 都可以使用这个运算符; 分别查看所有的 字段 参考了解具体用法。 示例
不是 IS NOT" 注意不是所有的 字段 都可以使用这个运算符; 分别查看所有的 字段 参考了解具体用法。 示例
|
影响版本搜索指定影响版本的问题。 你可以按照版本名称或版本ID(JIRA自动为版本分配的数值)搜索 。
注意: 这个字段支持 自动完成。 语法
字段类型版本 VERSION 支持的操作符注意比较运算符 (如 ">") 使用 版本排序(链接到Atlassian网站) 只按照JIRA管理员设置的顺序, 而不按照数值或字母顺序。 支持的函数当使用 在...之内(IN) 和 不在...之内(NOT IN) 运算符时, 示例
经办人搜索经办人是指定用户的问题。 你可以使用用户全名、ID或电子邮件地址。 注意: 这个字段支持 自动完成。 语法
字段类型用户 USER 支持的运算符支持的函数当使用 #IN 和 #NOT_IN 运算符时, 当使用 等于 和 不等于 运算符时, 示例
类别搜索属于指定项目类别的项目下的所有问题。 注意: 这个字段支持 自动完成。 语法
字段类型类别 CATEGORY 支持的运算符支持的函数n/a 示例
备注搜索备注中包含指定字符的问题。 可以使用JIRA 文本搜索语法 。 注意: 这个字段不支持 自动完成。 语法
字段类型文本 TEXT 支持的运算符支持的函数n/a 示例
模块搜索一个项目中的指定 模块的问题。 你可以按照模块名称或模块ID (JIRA自动分配给模块的数字)搜索。
注意: 这个字段支持自动完成。 语法
字段类型模块 COMPONENT 支持的运算符支持的函数当使用 在...之内(IN) 和 不在...之内(NOT IN) 运算符时, 示例
创建日期按照指定的创建日期范围搜索问题。 注意: 这个字段不支持 自动完成。 语法
或者:
字段类型日期 DATE 支持的运算符支持的函数当使用 等于, 不等于, 大于, 大于等于, 小于 或 小于等于 运算符时, 示例
自定义字段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).
Note:
语法
Alias:
字段类型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:
支持的函数Different types of Custom Fields support different #functions. For the default Custom Field Types, the following functions are supported:
示例
DescriptionSearch for issues where the Description contains particular text. JIRA text-search syntax can be used. Note: this field does not support #auto-complete. 语法
字段类型TEXT 支持的运算符支持的函数n/a 示例
DueSearch for issues that were due on, before or after a particular date (or date range). Note that Due Date relates to the date only (not to the time). Note: this field does not support #auto-complete. 语法
Alias:
字段类型DATE 支持的运算符支持的函数When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators,
示例
EnvironmentSearch for issues where the Environment contains particular text. JIRA text-search syntax can be used. Note: this field does not support #auto-complete. 语法
字段类型TEXT 支持的运算符支持的函数n/a 示例
FilterYou 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).
Note:
字段类型FILTER 支持的运算符支持的函数n/a 示例
Fix VersionSearch 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).
注意: 这个字段支持自动完成。 语法
字段类型VERSION 支持的运算符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, 示例
Issue KeySearch 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. 语法
Aliases:
字段类型ISSUE 支持的运算符支持的函数When used with the #IN or #NOT_IN operators, 示例
LevelOnly 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).
注意: 这个字段支持自动完成。 语法
字段类型SECURITY LEVEL 支持的运算符支持的函数n/a 示例
Original EstimateOnly 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. 语法
Alias:
字段类型DURATION 支持的运算符支持的函数n/a 示例
ParentOnly 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. 语法
字段类型ISSUE 支持的运算符支持的函数n/a 示例
PrioritySearch 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).
注意: 这个字段支持自动完成。 语法
字段类型PRIORITY 支持的运算符支持的函数n/a 示例
ProjectSearch 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 支持的运算符支持的函数When used with the #IN and #NOT_IN operators, 示例
Remaining EstimateOnly 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. 语法
Alias:
字段类型DURATION 支持的运算符支持的函数n/a 示例
ReporterSearch 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. 注意: 这个字段支持自动完成。 语法
字段类型USER 支持的运算符支持的函数When used with the #IN and #NOT_IN operators, When used with the #EQUALS and #NOT_EQUALS operators, 示例
ResolutionSearch 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).
注意: 这个字段支持自动完成。 语法
字段类型RESOLUTION 支持的运算符支持的函数n/a 示例
ResolvedSearch for issues that were resolved on, before or after a particular date (or date range). Note: this field does not support #auto-complete. 语法
Alias:
字段类型DATE 支持的运算符支持的函数When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators,
示例
StatusSearch 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).
注意: 这个字段支持自动完成。 语法
字段类型STATUS 支持的运算符支持的函数n/a 示例
SummarySearch for issues where the Summary contains particular text. JIRA text-search syntax can be used. Note: this field does not support #auto-complete. 语法
字段类型TEXT 支持的运算符支持的函数n/a 示例
TextThis is a "master-field" that allows you to search all text fields, i.e.: Note: The 语法
字段类型TEXT 支持的运算符支持的函数n/a 示例
TypeSearch 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).
注意: 这个字段支持自动完成。 语法
Alias:
字段类型ISSUE_TYPE 支持的运算符支持的函数n/a 示例
Time SpentOnly 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. 语法
字段类型DURATION 支持的运算符支持的函数n/a 示例
UpdatedSearch for issues that were last updated on, before or after a particular date (or date range). Note: this field does not support #auto-complete. 语法
Alias:
字段类型DATE 支持的运算符支持的函数When used with the #EQUALS, #NOT_EQUALS, #GREATER_THAN, #GREATER_THAN_EQUALS, #LESS_THAN or #LESS_THAN_EQUALS operators,
示例
VoterSearch 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. 注意: 这个字段支持自动完成。 语法
字段类型USER 支持的运算符支持的函数When used with the #IN and #NOT_IN operators, When used with the #EQUALS and #NOT_EQUALS operators, 示例
VotesSearch for issues with a specified number of votes. Note: this field does not support #auto-complete. 语法
字段类型NUMBER 支持的运算符支持的函数n/a 示例
WatcherSearch 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. 注意: 这个字段支持自动完成。 语法
字段类型USER 支持的运算符支持的函数When used with the #IN and #NOT_IN operators, When used with the #EQUALS and #NOT_EQUALS operators, 示例
Work RatioOnly 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. 语法
字段类型NUMBER 支持的运算符支持的函数n/a 示例
|
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 语法
or
Supported Field TypesCASCADING_OPTION 支持的运算符示例
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. 语法
or
Supported Field TypesCOMPONENT 支持的运算符示例
currentLogin()Perform searches based on the time at which the current user's session began. See also #lastLogin. 语法
Supported Field TypesDATE 支持的运算符示例
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. 语法
Supported Field TypesUSER 支持的运算符示例
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:
语法
Supported Field TypesISSUE 支持的运算符示例
lastLogin()Perform searches based on the time at which the current user's previous session began. See also #currentLogin. 语法
Supported Field TypesDATE 支持的运算符示例
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. 语法
or
Supported Field TypesISSUE 支持的运算符示例
membersOf()Perform searches based on the members of a particular group. 语法
Supported Field TypesUSER 支持的运算符示例
now()Perform searches based on the current time. 语法
Supported Field TypesDATE 支持的运算符示例
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. 语法
or
Supported Field TypesPROJECT 支持的运算符示例
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. 语法
For the Supported Field TypesPROJECT 支持的运算符示例
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. 语法
Supported Field TypesPROJECT 支持的运算符示例
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. 语法
or
Supported Field TypesVERSION 支持的运算符示例
standardIssueTypes()Perform searches based on "standard" Issue Types, that is, search for issues which are not sub-tasks. 语法
Supported Field TypesISSUE_TYPE 支持的运算符示例
subtaskIssueTypes()Perform searches based on issues which are sub-tasks. 语法
Supported Field TypesISSUE_TYPE 支持的运算符示例
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. 语法
or
Supported Field TypesVERSION 支持的运算符示例
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. 语法
Supported Field TypesISSUE 支持的运算符示例
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. 语法
Supported Field TypesISSUE 支持的运算符示例
Supported Field TypesISSUE 支持的运算符示例
|
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.
You can also use parentheses to group clauses, so that you can apply the #NOT operator to the group.
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:
As you type your query, JIRA will recognise the context and offer a list of "auto-complete" suggestions as follows:
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.
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......JIRA will offer a list of all available fields, e.g.:
If you type one or more characters......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......JIRA will offer a list of valid values (if your #field supports this) and valid functions for the field/operator combination, e.g.:
|
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:
project in (A, B)
)
(project = JRA OR project = CONF)
is equivalent to this query:(project in (JRA, CONF))
, only the second query will be translated.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
JQL has a list of reserved characters. These characters need to be surrounded by quote-marks if you wish to use them in queries:
" "
)"+"
"."
","
";"
"?"
"|"
"'"
"*"
"/"
"%"
"^"
"$"
"#"
"@"
You can use either single 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:
.
JQL保留了一些专用的单词. 如果你需要在查询语句中使用下面的单词,必须用引号将其括起来:
"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"
你既可以使用单引号 ( |
(JIRA管理员请注意: 上面列表是 JqlStringSupportImpl.java
文件的固定编码。)
注意还有一些其他 文本搜索的保留字段, which applies to the following fields:
.