Documentation for JIRA 6.3. Not using this? See below:
(JIRA 6.2.x documentation | JIRA Cloud documentation | earlier versions of JIRA)

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: corrected a "releasedVersions" code sample

...

Table of Content Zone
maxLevel4
locationtop
minLevel4
typelist

Anchor
cascadeOption
cascadeOption

cascadeOption()

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

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

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

Syntax
Code Block
cascadeOption(parentOption)

or

Code Block
cascadeOption(parentOption,childOption)
Supported Fields
  • custom fields of type 'Cascading Select'
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues where a custom field ("Location") has the value "USA" for the first tier and "New York" for the second tier:

    Code Block
    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:

    Code Block
    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:

    Code Block
    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:

    Code Block
    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:

    Code Block
    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:

    Code Block
    referrer in cascadeOption("\"none\"",none)

^top of functions | ^^top of topic

Anchor
componentsLeadByUser
componentsLeadByUser

componentsLeadByUser()

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

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

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

Syntax
Code Block
componentsLeadByUser()

or

Code Block
componentsLeadByUser(username)
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find open issues in components that are lead by you:

    Code Block
    component in componentsLeadByUser() AND status = Open
  • Find open issues in components that are lead by Bill:

    Code Block
    component in componentsLeadByUser(bill) AND status = Open

^top of functions | ^^top of topic

Anchor
currentLogin
currentLogin

currentLogin()

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

Syntax
Code Block
currentLogin()
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues that have been created during my current session:

    Code Block
    created > currentLogin()

^top of functions | ^^top of topic

Anchor
currentUser
currentUser

currentUser()

Perform searches based on the currently logged-in user.

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

Syntax
Code Block
currentUser()
Supported Fields
Include Page
__JQL User Fields
nopaneltrue
__JQL User Fields
Supported Operators
Include Page
__JQLOpSBUserFunctions
nopaneltrue
__JQLOpSBUserFunctions
Examples
  • Find issues that are assigned to me:

    Code Block
    assignee = currentUser()
  • Find issues that were reported to me but are not assigned to me:

    Code Block
    reporter = currentUser() and assignee != currentUser()

^top of functions | ^^top of topic

Anchor
earliestUnreleasedVersion
earliestUnreleasedVersion

earliestUnreleasedVersion()

Perform searches based on the earliest unreleased version (i.e. next version that is due to be released) of a specified project. See also unreleasedVersions.

Note that the "earliest" is determined by the ordering assigned to the versions, not by actual Version Due Dates.

Syntax
Code Block
earliestUnreleasedVersion(project)
Supported Fields
Include Page
__JQL Version Fields
nopaneltrue
__JQL Version Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues whose FixVersion is the earliest unreleased version of the ABC project:

    Code Block
    fixVersion = earliestUnreleasedVersion(ABC)
  • Find issues that relate to the earlist unreleased version of the ABC project:

    Code Block
    affectedVersion = earliestUnreleasedVersion(ABC) or fixVersion = earliestUnreleasedVersion(ABC)

^top of functions | ^^top of topic

Anchor
endOfDay
endOfDay

endOfDay()

Perform searches based on the end of the current day. See also endOfWeek, endOfMonth and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear.

Syntax
Code Block
endOfDay()

or

Code Block
endOfDay("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. endOfDay("+1") is the same as endOfDay("+1d").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues due by the end of today:

    Code Block
    due < endOfDay()
  • Find issues due by the end of tomorrow:

    Code Block
    due < endOfDay("+1")

^top of functions | ^^top of topic

Anchor
endOfMonth
endOfMonth

endOfMonth()

Perform searches based on the end of the current month. See also endOfDay, endOfWeek and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear.

Syntax
Code Block
endOfMonth()

or

Code Block
endOfMonth("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. endOfMonth("+1") is the same as endOfMonth("+1M").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues due by the end of this month:

    Code Block
    due < endOfMonth()
  • Find issues due by the end of next month:

    Code Block
    due endOfMonth("+1")
  • Find issues due by the 15th of next month:

    Code Block
    due endOfMonth("+15d")

^top of functions | ^^top of topic

Anchor
endOfWeek
endOfWeek

endOfWeek()

Perform searches based on the end of the current week. See also endOfDay, endOfMonth and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear.

For the endOfWeek() function the result depends upon your locale. For example, in Europe the first day of the week is generally considered to be Monday, while in the USA it is considered to be Sunday.

Syntax
Code Block
endOfWeek()

or

Code Block
endOfWeek("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. endOfWeek("+1") is the same as endofWeek("+1w").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues due by the end of this week:

    Code Block
    due < endOfWeek()
  • Find issues due by the end of next week:

    Code Block
    due < endOfWeek("+1")

^top of functions | ^^top of topic

Anchor
endOfYear
endOfYear

endOfYear()

Perform searches based on the end of the current year. See also startOfDay, startOfWeek and startOfMonth; and endOfDay, endOfWeek, endOfMonth and endOfYear.

Code Block
startOfYear()

or

Code Block
startOfYear("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. endOfYear("+1") is the same as endofYear("+1y").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues due by the end of this year:

    Code Block
    due < endOfYear()
  • Find issues due by the end of March next year:

    Code Block
    due < endOfYear("+3M")

^top of functions | ^^top of topic

Anchor
issueHistory
issueHistory

issueHistory()

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

Note:

  • issueHistory() returns up to 50 issues, whereas the 'Recent Issues' drop-down returns only 5.
  • if you are not logged in to JIRA, only issues from your current browser session will be included.
Syntax
Code Block
issueHistory()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues which I have recently viewed, that are assigned to me:

    Code Block
    issue in issueHistory() AND assignee = currentUser()

^top of functions | ^^top of topic

Anchor
lastLogin
lastLogin

lastLogin()

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

Syntax
Code Block
currentLogin()
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues that have been created during my last session:

    Code Block
    created > lastLogin()

^top of functions | ^^top of topic

Anchor
latestReleasedVersion
latestReleasedVersion

latestReleasedVersion()

Perform searches based on the latest released version (i.e. the most recent version that has been released) of a specified project. See also releasedVersions().

Note that the "latest" is determined by the ordering assigned to the versions, not by actual Version Due Dates.

Syntax
Code Block
latestReleasedVersion(project)
Supported Fields
Include Page
__JQL Version Fields
nopaneltrue
__JQL Version Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues whose FixVersionis the latest released version of the ABC project:

    Code Block
    fixVersion = latestReleasedVersion(ABC)
  • Find issues that relate to the latest released version of the ABC project:

    Code Block
    affectedVersion = latestReleasedVersion(ABC) or fixVersion = latestReleasedVersion(ABC)

^top of functions | ^^top of topic

Anchor
linkedIssues
linkedIssues

linkedIssues()

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

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

Syntax
Code Block
linkedIssues(issueKey)

or

Code Block
linkedIssues(issueKey,linkType)
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that are linked to a particular issue:

    Code Block
    issue in linkedIssues(ABC-123)
  • Find issues that are linked to a particular issue via a particular type of link:

    Code Block
    issue in linkedIssues(ABC-123,"is duplicated by")

^top of functions | ^^top of topic

Anchor
membersOf
membersOf

membersOf()

Perform searches based on the members of a particular group.

Syntax
Code Block
membersOf(Group)
Supported Fields
Include Page
__JQL User Fields
nopaneltrue
__JQL User Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues where the Assignee is a member of the group "jira-developers":

    Code Block
    assignee in membersOf("jira-developers")
  • Search through multiple groups and a specific user, e.g:

    Code Block
    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.:

    Code Block
    assignee in membersOf(QA) and assignee not in ("John Smith","Jill Jones")
  • Exclude members of a particular group:

    Code Block
    assignee not in membersOf(QA)

^top of functions | ^^top of topic

Anchor
now
now

now()

Perform searches based on the current time.

Syntax
Code Block
now()
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find issues that are overdue:

    Code Block
    duedate < now() and status not in (closed, resolved) 

^top of functions | ^^top of topic

Anchor
projectsLeadByUser
projectsLeadByUser

projectsLeadByUser()

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

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

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

Syntax
Code Block
projectsLeadByUser()

or

Code Block
projectsLeadByUser(username)
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find open issues in projects that are lead by you:

    Code Block
    project in projectsLeadByUser() AND status = Open
  • Find open issues in projects that are lead by Bill:

    Code Block
    project in projectsLeadByUser(bill) AND status = Open

^top of functions | ^^top of topic

Anchor
projectsWhereUserHasPermission
projectsWhereUserHasPermission

projectsWhereUserHasPermission()

Find issues in projects where you have a specific permission.

Note: This function operates at the project level. This means that if a permission (e.g. "Edit Issues") is granted to the reporter of issues in a project, then you may see some issues returned where you are
not the reporter and therefore don't have the permission specified.

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

Syntax
Code Block
projectsWhereUserHasPermission(permission)

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

Include Page
__project permissions
nopaneltrue
__project permissions
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find open issues in projects where you have the "Resolve Issues" permission:

    Code Block
    project in projectsWhereUserHasPermission("Resolve Issues") AND status = Open

^top of functions | ^^top of topic

Anchor
projectsWhereUserHasRole
projectsWhereUserHasRole

projectsWhereUserHasRole()

Find issues in projects where you have a specific role.

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

Syntax
Code Block
projectsWhereUserHasRole(rolename)
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find open issues in projects where you have the "Developers" role:

    Code Block
    project in projectsWhereUserHasRole("Developers") AND status = Open

^top of functions | ^^top of topic

Anchor
releasedVersions
releasedVersions

releasedVersions()

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

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

See also latestReleasedVersion().

Syntax
Code Block
releasedVersions()

or

Code Block
releasedVersions(project)
Supported Fields
Include Page
__JQL Version Fields
nopaneltrue
__JQL Version Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues whose FixVersion is a released version of the ABC project:

    Code Block
    fixVersion in releasedVersions(ABC)
  • Find issues that relate to released versions of the ABC project:

    Code Block
    (affectedVersion in releasedVersions(ABC)

    or

    Code Block
    ) or (fixVersion in releasedVersions(ABC))

^top of functions | ^^top of topic

Anchor
standardIssuesTypes
standardIssuesTypes

standardIssueTypes()

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

See also subtaskIssueTypes().

Syntax
Code Block
standardIssueTypes()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that are not subtasks (i.e. issues whose Issue Type is a standard issue type, not a subtask issue type):

    Code Block
    issuetype in standardIssueTypes()

^top of functions | ^^top of topic

Anchor
startOfDay
startOfDay

startOfDay()

Perform searches based on the start of the current day. See also startOfWeek, startOfMonth and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear.

Syntax
Code Block
startOfDay()

or

Code Block
startOfDay("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. startOfDay("+1") is the same as startofDay("+1d").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find new issues created since the start of today:

    Code Block
    created > startOfDay()
  • Find new issues created since the start of yesterday:

    Code Block
    created > startOfDay("-1")
  • Find new issues created in the last three days:

    Code Block
    created > startOfDay("-3d")

^top of functions | ^^top of topic

Anchor
startOfMonth
startOfMonth

startOfMonth()

Perform searches based on the start of the current month. See also startOfDay, startOfWeek and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear.

Syntax
Code Block
startOfMonth()

or

Code Block
startOfMonth("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. startOfMonth("+1") is the same as startofMonth("+1M").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find new issues since the start of this month:

    Code Block
    created > startOfMonth()
  • Find new issues since the start of last month:

    Code Block
    created > startOfMonth("-1")
  • Find new issues since the 15th of this month:

    Code Block
    created > startOfMonth("+14d")

^top of functions | ^^top of topic

Anchor
startOfWeek
startOfWeek

startOfWeek()

Perform searches based on the start of the current week. See also startOfDay, startOfMonth and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear.

For the startOfWeek() function the result depends upon your locale. For example, in Europe the first day of the week is generally considered to be Monday, while in the USA it is considered to be Sunday.

Syntax
Code Block
startOfWeek()

or

Code Block
startOfWeek("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. startOfWeek("+1") is the same as startofWeek("+1w").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find new issues since the start of this week:

    Code Block
    created > startOfWeek()
  • Find new issues since the start of last week:

    Code Block
    created > startOfWeek("-1")

^top of functions | ^^top of topic

Anchor
startOfYear
startOfYear

startOfYear()

Perform searches based on the start of the current year. See also startOfDay, startOfWeek and startOfMonth; and endOfDay, endOfWeek, endOfMonth and endOfYear.

Code Block
startOfYear()

or

Code Block
startOfYear("inc")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m)

  • If the time unit qualifier is omitted it defaults to the natural period of the function, e.g. startOfYear("+1") is the same as startofYear("+1y").
  • If the plus/minus (+/-) sign is omitted, plus is assumed.
Supported Fields
Include Page
__JQL Date Fields
nopaneltrue
__JQL Date Fields
Supported Operators
Include Page
__JQLOpSBDateFunctions
nopaneltrue
__JQLOpSBDateFunctions
Examples
  • Find new issues since the start of this year:

    Code Block
    created > startOfYear()
  • Find new issues since the start of last year:

    Code Block
    created > startOfYear("-1")

^top of functions | ^^top of topic

Anchor
subtaskIssuesTypes
subtaskIssuesTypes

subtaskIssueTypes()

Perform searches based on issues which are sub-tasks.

See also standardIssueTypes().

Syntax
Code Block
subtaskIssueTypes()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that are subtasks (i.e. issues whose Issue Type is a subtask issue type):

    Code Block
    issuetype in subtaskIssueTypes()

^top of functions | ^^top of topic

Anchor
unreleasedVersions
unreleasedVersions

unreleasedVersions()

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

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

See also earliestUnreleasedVersion().

Syntax
Code Block
unreleasedVersions()

or

Code Block
unreleasedVersions(project)
Supported Fields
Include Page
__JQL Version Fields
nopaneltrue
__JQL Version Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues whose FixVersionis an unreleased version of the ABC project:

    Code Block
    fixVersion in unreleasedVersions(ABC)
  • Find issues that relate to unreleased versions of the ABC project:

    Code Block
    affectedVersion in unreleasedVersions(ABC)

    or

    Code Block
    fixVersion in unreleasedVersions(ABC)

^top of functions | ^^top of topic

Anchor
votedIssues
votedIssues

votedIssues()

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

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

Syntax
Code Block
votedIssues()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that you have voted for:

    Code Block
    issue in votedIssues()

^top of functions | ^^top of topic

Anchor
watchedIssues
watchedIssues

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
Code Block
watchedIssues()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that you are watching:

    Code Block
    issue in watchedIssues()
Supported Fields
Supported Operators
Include Page
__JQLOpSBTextFunctions
nopaneltrue
__JQLOpSBTextFunctions
Examples
  • Find issues that you have recently viewed:

    Code Block
    issue in issueHistory()

^top of functions | ^^top of topic

...