...
内容区目录 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
与 AND用于整合多个查询条件, 允许你精炼查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 示例
或 OR用户整合多个查询条件, 允许你扩展查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 (注意: 也可以查看 在...之中(IN)章节, 使用更方便的方法搜索多个字段的值。) 示例
非 NOT用于否定一个运算符或整个查询条件, 允许你优化查询条件。 注意,你可以使用 括号 来控制查询条件的执行顺序。 (注意: 也可以查看 不等于 ("!="), 不包括 ("!~"), 不再...之中 和 不是章节) 示例
空 EMPTY用于搜索没有值的字段。 也可以查看空(NULL)。 注意 EMPTY 只能与 是(IS) 和 不是(IS NOT) 运算符结合使用。 要查看字段支持的运算符, 点击 #字段 。 示例
空 NULL用于搜索字段没有赋值的问题。 请查看 空(EMPTY)。 注意 NULL 只能用于支持 是(IS) 和 不是(IS NOT) 操作符的字段。 要了解字段支持哪些操作符, 请查看每个 字段 参考。 示例
排序 ORDER BY用于对输出的结果,按照指定的字段排序。 默认情况下, 按照字段输出顺序排序。 你可以指定按照升序 (" 示例
|
...
内容区目录 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
影响版本搜索指定影响版本的问题。 你可以按照版本名称或版本ID(JIRA自动为版本分配的数值)搜索 。
注意: 这个字段支持 自动完成。 语法
字段类型VERSION 支持的操作符
注意比较运算符 (如 ">") 使用 版本排序(链接到Atlassian网站) 只按照JIRA管理员设置的顺序, 而不按照数值或字母顺序。 支持的函数When used with the #IN and #NOT_IN operators, 示例
经办人Search for issues that are assigned to a particular user. You can search by the user's Full Name, ID or Email Address. 搜索经办人是指定用户的问题。 你可以使用用户全名、ID或电子邮件地址。 注意: 这个字段支持 自动完成。Note: this field supports #auto-complete. 语法
字段类型USER 支持的运算符
支持的函数When used with the #IN and 当使用 #IN 和 #NOT_IN operators 运算符时, When used with the #EQUALS and #NOT_EQUALS operators, 示例
CategorySearch for issues that belong to projects in a particular Category. Note: this field supports #auto-complete. 语法
字段类型CATEGORY 支持的运算符
支持的函数n/a 示例
CommentSearch 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. 语法
字段类型TEXT 支持的运算符
支持的函数n/a 示例
ComponentSearch 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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型COMPONENT 支持的运算符
支持的函数When used with the #IN and #NOT_IN operators, 示例
CreatedSearch for issues that were created 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, 示例
Custom FieldOnly 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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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). Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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. Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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).
注意: 这个字段支持自动完成。Note: this field supports #auto-complete. 语法
字段类型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).
Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
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. Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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. Note: this field supports #auto-complete. 注意: 这个字段支持自动完成。 语法
字段类型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 示例
|
...
Note that there is an additional list of reserved characters for Text Searches, which applies to the following fields:
包含页面 | ||||||
---|---|---|---|---|---|---|
|
锚 | ||||
---|---|---|---|---|
|
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 你既可以使用单引号 ( |
(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:
包含页面 | ||||||
---|---|---|---|---|---|---|
|