页面历史记录

影响版本

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

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

语法

affectedVersion

字段类型

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. 使用 版本排序(链接到Atlassian网站) 只按照JIRA管理员设置的顺序, 而不按照数值或字母顺序。

支持的函数

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

• #releasedVersions()
• #unreleasedVersions()

示例

• 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:

  代码块
  affectedVersion = 10350

经办人

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.

语法

assignee

字段类型

USER

支持的运算符

支持的函数

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

• #membersOf()

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

• #currentUser()

示例

• 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

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

Note: this field supports #auto-complete.

语法

category

字段类型

CATEGORY

支持的运算符

支持的函数

n/a

示例

• Find issues that belong to projects in the "Alphabet Projects" Category:

  代码块
  category = "Alphabet Projects"

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.

语法

comment

字段类型

TEXT

支持的运算符

支持的函数

n/a

示例

• Find issues where a Comment contains text that matches "My PC is quite old" (i.e. a "fuzzy" match:

  代码块
  comment ~ "My PC is quite old"

• Find issues where a Comment contains the exact phrase "My PC is quite old":

  代码块
  comment ~ "\"My PC is quite old\""

Component

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

Note: this field supports #auto-complete.

语法

component

字段类型

COMPONENT

支持的运算符

支持的函数

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

• #componentsLeadByUser()

示例

• 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:

  代码块
  component = 20500

Created

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

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

语法

created

Alias:

createdDate

字段类型

DATE

支持的运算符

支持的函数

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

• #currentLogin()
• #lastLogin()
• #now()

示例

• Find all issues created on or before 12th December 2008 00:00:

  代码块
  created <= "2008/12/12"

• Find issues created less than one day ago:

  代码块
  created > "-1d"

• Find issues created in January 2009:

  代码块
  created > "2008/12/31" and created < "2009/02/01"

• Find issues created on 15 January 2009:

  代码块
  created > "2009/01/14" and created < "2009/01/16"

Custom Field

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

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

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

Note:

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

语法

CustomFieldName

Alias:

cf[CustomFieldID]

字段类型

Depends on the Custom Field's configuration

支持的运算符

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

• Number and date/time fields:

  包含页面
  quickstart:__JQL Operators supported by Numeric Fields quickstart:__JQL Operators supported by Numeric Fields nopanel true

• Picker, select, check-box and radio button fields:

  包含页面
  quickstart:__JQL Operators supported by Select Fields quickstart:__JQL Operators supported by Select Fields nopanel true

• Text fields:

  包含页面
  quickstart:__JQL Operators supported by Text Fields quickstart:__JQL Operators supported by Text Fields nopanel true

支持的函数

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)

示例

• Find issues where the value of the "Location" Custom Field is "New York":

  代码块
  location = "New York"

• Find issues where the value of the Custom Field with ID 10003 is "New York":

  代码块
  cf[10003] = "New York"

• Find issues where the value of the "Location" Custom Field is "London" or "Milan" or "Paris":

  代码块
  cf[10003] in ("London", "Milan", "Paris")

• Find issues where the "Location" Custom Field has no value:

  代码块
  location != empty

Description

Search for issues where the Description contains particular text.

JIRA text-search syntax can be used.

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

语法

description

字段类型

TEXT

支持的运算符

支持的函数

n/a

示例

• Find issues where the Description contains text that matches "Please see screenshot" (i.e. a "fuzzy" match):

  代码块
  description ~ "Please see screenshot"

• Find issues where the Description contains the exact phrase "Please see screenshot":

  代码块
  description ~ "\"Please see screenshot\""

Due

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

语法

due

Alias:

dueDate

字段类型

DATE

支持的运算符

支持的函数

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

• #currentLogin()
• #lastLogin()
• #now()

示例

• Find all issues due on or before 31st December 2008:

  代码块
  due <= "2008/12/31"

• Find issues that are due tomorrow:

  代码块
  due = "1d"

• Find issues that were due in January 2009:

  代码块
  due > "2008/12/31" and due < "2009/02/01"

• Find issues that were due on 15 January 2009:

  代码块
  due > "2009/01/14" and due < "2009/01/16"

Environment

Search for issues where the Environment contains particular text.

JIRA text-search syntax can be used.

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

语法

environment

字段类型

TEXT

支持的运算符

支持的函数

n/a

示例

• Find issues where the Environment contains text that matches "Third floor" (i.e. a "fuzzy" match):

  代码块
  environment ~ "Third floor"

• Find issues where the Environment contains the exact phrase "Third floor":

  代码块
  environment ~ "\"Third floor\""

Filter

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

Note:

• An #ORDER BY statement in your typed query will override an ORDER BY statement in the saved filter.
• You cannot run or save a filter that would cause an infinite loop (i.e. you cannot reference a saved filter if it eventually references your current filter).
• This field supports #auto-complete.

  语法

  代码块
  filter

  Aliases:

  代码块
  request

  代码块
  savedFilter

  代码块
  searchRequest

字段类型

FILTER

支持的运算符

支持的函数

n/a

示例

• Search the results of the filter "My Saved Filter" (which has an ID of 12000) for issues assigned to the user jsmith:

  代码块
  filter = "My Saved Filter" and assignee = jsmith

  or

  代码块
  filter = 12000 and assignee = jsmith

Fix Version

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

Note: this field supports #auto-complete.

语法

fixVersion

字段类型

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, fixVersion supports:

• #releasedVersions()
• #unreleasedVersions()

示例

• Find issues with a Fix Version of 3.14 or 4.2:

  代码块
  fixVersion in ("3.14", "4.2")

  (Note that full-stops are reserved #characters, so they need to be surrounded by quote marks.)
• Find issues with a Fix Version of "Little Ted":

  代码块
  fixVersion = "Little Ted"

• Find issues with a Fix Version ID of 10001:

  代码块
  fixVersion = 10001

Issue Key

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

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

语法

issueKey

Aliases:

id

issue

key

字段类型

ISSUE

支持的运算符

支持的函数

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

• #issueHistory()
• #linkedIssues()
• #votedIssues()
• #watchedIssues()

示例

• Find the issue with key "ABC-123":

  代码块
  issueKey = ABC-123

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

Note: this field supports #auto-complete.

语法

level

字段类型

SECURITY LEVEL

支持的运算符

支持的函数

n/a

示例

• Search for issues with a Security Level of "Really High" or "level1":

  代码块
  level in ("Really High", level1)

• Search for issues with a Security Level ID of 123:

  代码块
  level = 123

Original Estimate

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

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

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

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

语法

originalEstimate

Alias:

timeOriginalEstimate

字段类型

DURATION

支持的运算符

支持的函数

n/a

示例

• Find issues with an Original Estimate of 1 hour:

  代码块
  originalEstimate = 1h

• Find issues with an Original Estimate of more than 2 days:

  代码块
  originalEstimate > 2d

Parent

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

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

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

语法

parent

字段类型

ISSUE

支持的运算符

支持的函数

n/a

示例

• Find issues that are sub-tasks of issue TEST-1234:

  代码块
  parent = TEST-1234

Priority

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

Note: this field supports #auto-complete.

语法

priority

字段类型

PRIORITY

支持的运算符

支持的函数

n/a

示例

• Find issues with a Priority of "High":

  代码块
  priority = High

• Find issues with a Priority ID of 10000:

  代码块
  priority = 10000

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.

语法

project

字段类型

PROJECT

支持的运算符

支持的函数

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

• #projectsLeadByUser()
• #projectsWhereUserHasPermission()
• #projectsWhereUserHasRole()

示例

• Find issues that belong to the Project that has the name "ABC Project":

  代码块
  project = "ABC Project"

• Find issues that belong to the Project that has the key "ABC":

  代码块
  project = "ABC"

• Find issues that belong to the Project that has the ID "1234":

  代码块
  project = 1234

Remaining Estimate

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

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

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

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

语法

remainingEstimate

Alias:

timeEstimate

字段类型

DURATION

支持的运算符

支持的函数

n/a

示例

• Find issues with a Remaining Estimate of more than 4 hours:

  代码块
  remainingEstimate > 4h

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.

语法

reporter

字段类型

USER

支持的运算符

支持的函数

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

• #membersOf()

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

• #currentUser()

示例

• Search for issues that were created by Jill Jones:

  代码块
  reporter = "Jill Jones"

  or

  代码块
  reporter = jjones

• Search for issues that were created by the user with email address "bob@mycompany.com":

  代码块
  assignee = "bob@mycompany.com"

  (Note that full-stops and "@" symbols are reserved #characters, so the email address needs to be surrounded by quote-marks.)

Resolution

Search for issues that have a particular Resolution

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

Note: this field supports #auto-complete.

语法

resolution

字段类型

RESOLUTION

支持的运算符

支持的函数

n/a

示例

• Find issues with a Resolution of "Cannot Reproduce" or "Won't Fix":

  代码块
  resolution in ("Cannot Reproduce", "Won't Fix")

• Find issues with a Resolution ID of 5:

  代码块
  resolution = 5

• Find issues that do not have a Resolution:

  代码块
  resolution = unresolved

Resolved

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

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

语法

resolved

Alias:

resolutionDate

字段类型

DATE

支持的运算符

支持的函数

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

• #currentLogin()
• #lastLogin()
• #now()

示例

• Find all issues that were resolved on or before 31st December 2008 00:00:

  代码块
  resolved <= "2008/12/31"

• Find issues that were resolved in January 2009:

  代码块
  resolved > "2008/12/31" and resolved < "2009/02/01"

• Find issues that were resolved on 15 January 2009:

  代码块
  resolved > "2009/01/14" and resolved < "2009/01/16"

• Find issues that were resolved in the last hour:

  代码块
  resolved > -1h

Status

Search for issues that have a particular Status.

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

Note: this field supports #auto-complete.

语法

status

字段类型

STATUS

支持的运算符

支持的函数

n/a

示例

• Find issues with a Status of "Open":

  代码块
  status = Open

• Find issues with a Status ID of 1:

  代码块
  status = 1

Summary

Search for issues where the Summary contains particular text.

JIRA text-search syntax can be used.

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

语法

summary

字段类型

TEXT

支持的运算符

支持的函数

n/a

示例

• Find issues where the Summary contains text that matches "Error saving file" (i.e. a "fuzzy" match):

  代码块
  summary ~ "Error saving file"

• Find issues where the Summary contains the exact phrase "Error saving file":

  代码块
  summary ~ "\"Error saving file\""

Text

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

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

语法

text

字段类型

TEXT

支持的运算符

支持的函数

n/a

示例

• Find issues where a text field matches the word "Fred":

  代码块
  text ~ "Fred"

  or

  代码块
  text ~ Fred

• Find all issues where a text field contains the exact phrase "full screen":

  代码块
  text ~ "\"full screen\""

Type

Search for issues that have a particular Issue Type.

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

Note: this field supports #auto-complete.

语法

type

Alias:

issueType

字段类型

ISSUE_TYPE

支持的运算符

支持的函数

n/a

示例

• Find issues with an Issue Type of "Bug":

  代码块
  type = Bug

• Find issues with an Issue Type of "Bug" or "Improvement":

  代码块
  issueType in (Bug,Improvement)

• Find issues with an Issue Type ID of 2:

  代码块
  issueType = 2

Time Spent

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

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

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

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

语法

timeSpent

字段类型

DURATION

支持的运算符

支持的函数

n/a

示例

• Find issues where the Time Spent is more than 5 days:

  代码块
  timeSpent > 5d

Updated

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

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

语法

updated

Alias:

updatedDate

字段类型

DATE

支持的运算符

支持的函数

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

• #currentLogin()
• #lastLogin()
• #now()

示例

• Find issues that were updated on or before 12th December 2008 00:00:

  代码块
  updated <= "2008/12/12"

• Find issues that were updated more than two weeks ago:

  代码块
  updated < "-2w"

• Find issues that were updated on 15 January 2009:

  代码块
  updated > "2009/01/14" and updated < "2009/01/16"

• Find issues that were updated in January 2009:

  代码块
  updated > "2008/12/31" and updated < "2009/02/01"

Voter

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.

语法

voter

字段类型

USER

支持的运算符

支持的函数

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

• #membersOf()

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

• #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

Search for issues with a specified number of votes.

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

语法

votes

字段类型

NUMBER

支持的运算符

支持的函数

n/a

示例

• Find all issues that have 12 or more votes:

  代码块
  votes >= 12

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.

语法

voter

字段类型

USER

支持的运算符

支持的函数

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

• #membersOf()

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

• #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")

Work Ratio

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

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

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

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

语法

workRatio

字段类型

NUMBER

支持的运算符

支持的函数

n/a

示例

• Find issues on which more than 75% of the Original Estimate has been spent:

  代码块
  workRatio > 75