页面历史记录

与 AND

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

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

示例

• 查询"New office"项目中所有开放的问题:

  代码块
  project = "New office" and status = "open"

• 查询所有分配给jsmith的紧急的开放问题:

  代码块
  status = open and priority = urgent and assignee = jsmith

• 查询JRA项目中没有分配给jsmith的问题:

  代码块
  project = JRA and assignee != jsmith

• 查找JRA和CONF项目中修复版本是3.14的问题:

  代码块
  project in (JRA,CONF) and fixVersion = "3.14"

• 查找不是Jack,Jill,John报告的并且他们也不是经办人的问题:

  代码块
  reporter not in (Jack,Jill,John) and assignee not in (Jack,Jill,John)

或 OR

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

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

(注意: 也可以查看 #IN 在...之中(IN)章节, 使用更方便的方法搜索多个字段的值。)

示例

• 搜索报告人是jsmith或jbrown的问题:

  代码块
  reporter = jsmith or reporter = jbrown

• 搜索已近逾期或没有设置到期日的问题:

  代码块
  duedate < now() or duedate is empty

非 NOT

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

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

(注意: 也可以查看 #NOT_EQUALS 不等于 ("!="), #DOES_NOT_CONTAIN 不包括 ("!~"), #NOT_IN 和 #IS_NOT 不再...之中 和 不是章节)

示例

• 搜索经办人不是jsmith的所有问题:

  代码块
  not assignee = jsmith

• 搜索所有报告人不是jsmith或不是jbrown的问题:

  代码块
  not (reporter = jsmith or reporter = jbrown)

空 EMPTY

用于搜索没有值的字段。 也可以查看#NULL空(NULL)。

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

示例

• 搜索所有没有到期日(DueDate)的问题 :

  代码块
  duedate = empty

  or

  代码块
  duedate is empty

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

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

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

Note: this field supports #auto-complete.

Syntax

affectedVersion

Field Type

VERSION

Supported Operators

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:

• #releasedVersions()
• #unreleasedVersions()

Examples

示例

• 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

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

assignee

Field Type

USER

Supported Operators

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

示例

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

Syntax

category

Field Type

CATEGORY

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

comment

Field Type

TEXT

Supported Operators

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

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.

Syntax

component

Field Type

COMPONENT

Supported Operators

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:

  代码块
  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.

Syntax

created

Alias:

createdDate

Field Type

DATE

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

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:

  包含页面
  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

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

示例

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

Syntax

description

Field Type

TEXT

Supported Operators

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

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.

Syntax

due

Alias:

dueDate

Field Type

DATE

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

environment

Field Type

TEXT

Supported Operators

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

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.

  Syntax

  代码块
  filter

  Aliases:

  代码块
  request

  代码块
  savedFilter

  代码块
  searchRequest

Field Type

FILTER

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

fixVersion

Field Type

VERSION

Supported Operators

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:

• #releasedVersions()
• #unreleasedVersions()

Examples

示例

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

Syntax

issueKey

Aliases:

id

issue

key

Field Type

ISSUE

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

level

Field Type

SECURITY LEVEL

Supported Operators

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:

  代码块
  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.

Syntax

originalEstimate

Alias:

timeOriginalEstimate

Field Type

DURATION

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

parent

Field Type

ISSUE

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

priority

Field Type

PRIORITY

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

project

Field Type

PROJECT

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

remainingEstimate

Alias:

timeEstimate

Field Type

DURATION

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

reporter

Field Type

USER

Supported Operators

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

示例

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

Syntax

resolution

Field Type

RESOLUTION

Supported Operators

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:

  代码块
  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.

Syntax

resolved

Alias:

resolutionDate

Field Type

DATE

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

status

Field Type

STATUS

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

summary

Field Type

TEXT

Supported Operators

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

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 "!~").

Syntax

text

Field Type

TEXT

Supported Operators

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

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.

Syntax

type

Alias:

issueType

Field Type

ISSUE_TYPE

Supported Operators

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:

  代码块
  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.

Syntax

timeSpent

Field Type

DURATION

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

updated

Alias:

updatedDate

Field Type

DATE

Supported Operators

Supported Functions

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

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

Examples

示例

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

Syntax

voter

Field Type

USER

Supported Operators

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

示例

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

Syntax

votes

Field Type

NUMBER

Supported Operators

Supported Functions

n/a

Examples

示例

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

Syntax

voter

Field Type

USER

Supported Operators

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

示例

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

Syntax

workRatio

Field Type

NUMBER

Supported Operators

Supported Functions

n/a

Examples

示例

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

  代码块
  workRatio > 75

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(parentOption)

or

cascadeOption(parentOption,childOption)

Supported Field Types

CASCADING_OPTION

Supported Operators

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

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

componentsLeadByUser()

or

componentsLeadByUser(username)

Supported Field Types

COMPONENT

Supported Operators

Examples

示例

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

  代码块
  component in componentsLeadByUser(bill) AND status = Open

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

Examples

示例

• Find issues that have been created during my current session:

  代码块
  created > currentLogin()

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

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

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

issueHistory()

Supported Field Types

ISSUE

Supported Operators

Examples

示例

• Find issues which I have recently viewed, that are assigned to me:

  代码块
  issue in issueHistory() AND assignee = currentUser()

lastLogin()

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

Syntax

currentLogin()

Supported Field Types

DATE

Supported Operators

Examples

示例

• Find issues that have been created during my last session:

  代码块
  created > lastLogin()

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

Examples

示例

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

  代码块
  issue in linkedIssues(ABC-123,"is duplicated by")

membersOf()

Perform searches based on the members of a particular group.

Syntax

membersOf(Group)

Supported Field Types

USER

Supported Operators

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

• Exclude members of a particular group:

  代码块
  assignee not in membersOf(QA)

now()

Perform searches based on the current time.

Syntax

now()

Supported Field Types

DATE

Supported Operators

Examples

示例

• Find issues that are overdue:

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

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

projectsLeadByUser()

or

projectsLeadByUser(username)

Supported Field Types

PROJECT

Supported Operators

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:

  代码块
  project in projectsLeadByUser(bill) AND status = Open

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

projectsWhereUserHasPermission(permission)

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

Supported Field Types

PROJECT

Supported Operators

Examples

示例

• Find open issues in projects where you have the "Resolve Issues" permission:

  代码块
  project in projectsWhereUserHasPermission("Resolve Issues") AND status = Open

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

projectsWhereUserHasRole(rolename)

Supported Field Types

PROJECT

Supported Operators

Examples

示例

• Find open issues in projects where you have the "Developers" role:

  代码块
  project in projectsWhereUserHasRole("Developers") AND status = Open

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

Examples

示例

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

  代码块
  affectedVersion in releasedVersions(ABC)

  or

  代码块
  fixVersion in releasedVersions(ABC)

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

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

subtaskIssueTypes()

Perform searches based on issues which are sub-tasks.

Syntax

subtaskIssueTypes()

Supported Field Types

ISSUE_TYPE

Supported Operators

Examples

示例

• Find issues that are subtasks (i.e. issues whose Issue Type is a subtask issue type):

  代码块
  issuetype in subtaskIssueTypes()

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

Examples

示例

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

  代码块
  affectedVersion in unreleasedVersions(ABC)

  or

  代码块
  fixVersion in unreleasedVersions(ABC)

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

votedIssues()

Supported Field Types

ISSUE

Supported Operators

Examples

示例

• Find issues that you have voted for:

  代码块
  issue in votedIssues()

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

Examples

示例

• Find issues that you are watching:

  代码块
  issue in watchedIssues()

Supported Field Types

ISSUE

Supported Operators

Examples

示例

• Find issues that you have recently viewed:

  代码块
  issue in issueHistory()