Jira Software Support

This page describes information about functions that are used for advanced searching.

A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira system fields. In a clause, a function is preceded by an operator, which in turn is preceded by a field. A function performs a calculation on either specific Jira data or the function's content in parentheses, such that only true results are retrieved by the function, and then again by the clause in which the function is used.

Some Jira apps can add additional functions to the advanced issue search. For example, the ScriptRunner for JIRA app extends JQL with such functions as myProjects() and projectmatch().

Unless specified in the search query, note that JQL searches don't return empty fields in results. To include empty fields (e.g. unassigned issues) when searching for issues that are not assigned to the current user, you would enter (assignee != currentUser() OR assignee is EMPTY) to include unassigned issues in the list of results.

approved()

Only applicable if Jira Service Management is installed and licensed.

Search for issues that required approval and have a final decision of approved.

Syntax	approved()
Supported fields	Custom fields of type Approval
Supported operators	=
Unsupported operators	`~ , != , !~ ,` > , >= , < , <= `IS , IS NOT , IN , NOT IN ,` `WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find all issues that are approved: `approval = approved()`

Syntax	approver(user,user)
Supported fields	Custom fields of type Approval
Supported operators	=
Unsupported operators	`~ , != , !~ , > , >= , < , <= IS , IS NOT , IN , NOT IN , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues that require or required approval by John Smith: `approval = approver(jsmith)` Find issues that require or required approval by John Smith or Sarah Khan:`approval = approver(jsmith,skhan)`

Syntax	breached()
Supported fields
Supported operators	`= , !=`
Unsupported operators	`~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues where Time to First Response was breached: `"Time to First Response" = breached()`

Syntax	cascadeOption(parentOption) cascadeOption(parentOption,childOption)
Supported fields	Custom fields of type "Cascading Select"
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
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)`

Syntax	closedSprints()
Supported fields	Sprint
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find all issues that are assigned to a completed sprint: `sprint in closedSprints()`

Syntax	completed()
Supported fields
Supported operators	`= , !=`
Unsupported operators	= ,`~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues where Time to First Response has completed at least one cycle: `"Time to First Response" = completed()`

Syntax	componentsLeadByUser() componentsLeadByUser(username)
Supported fields	Component
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find open issues in components that are led by you: `component in componentsLeadByUser() AND status = Open` Find open issues in components that are led by Bill: `component in componentsLeadByUser(bill) AND status = Open`

Syntax	currentLogin()
Supported fields	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`_{ Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find issues that have been created during my current session: `created > currentLogin()`

Syntax	currentUser()
Supported fields	Assignee, Reporter, Voter, Watcher, custom fields of type User
Supported operators	`= , !=`
Unsupported operators	`~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
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() OR assignee is EMPTY)

Syntax	earliestUnreleasedVersion(project)
Supported fields	AffectedVersion, FixVersion, custom fields of type Version
Supported operators	`= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Unsupported operators	`IN , NOT IN`
Examples	Find issues whose FixVersion is the earliest unreleased version of the ABC project: `fixVersion = earliestUnreleasedVersion(ABC)` Find issues that relate to the earlist unreleased version of the ABC project: `affectedVersion = earliestUnreleasedVersion(ABC) or fixVersion = earliestUnreleasedVersion(ABC)`

Syntax	elapsed()
Supported fields
Supported operators	`= , != , > , >= , < , <=`
Unsupported operators	`~ , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues that have been waiting for a first response for more than 1 hour: `"Time to First Response" > elapsed("1h")`

Syntax	endOfDay() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find issues due by the end of today: `due < endOfDay()` Find issues due by the end of tomorrow: `due < endOfDay("+1")`

Syntax	endOfMonth() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find issues due by the end of this month: `due <= endOfMonth()` Find issues due by the end of next month: `due <= endOfMonth("+1")` Find issues due by the 15th of next month: `due <= endOfMonth("+15d")`

Syntax	endOfWeek() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find issues due by the end of this week: `due < endOfWeek()` Find issues due by the end of next week: `due < endOfWeek("+1")`

Syntax	endOfYear() endOfYear("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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find issues due by the end of this year: `due < endOfYear()` Find issues due by the end of March next year: `due < endOfYear("+3M")`

Syntax	futureSprints()
Supported fields	Sprint
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find all issues that are assigned to a sprint that hasn't been started yet: `sprint in futureSprints()`

Syntax	issueHistory()
Supported fields	Issue
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <=` `, IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues which I have recently viewed, that are assigned to me: `issue in issueHistory() AND assignee = currentUser()`

Syntax	issuesWithRemoteLinksByGlobalId()
Supported fields	Issue
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <=` `, IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues that are linked to remote links that have globalId "abc": `issue in issuesWithRemoteLinksByGlobalId(abc)` Find issues that are linked to remote links that have either globalId "abc" or "def": `issue in issuesWithRemoteLinksByGlobalId(abc, def)`

Syntax	lastLogin()
Supported fields	Created. Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` ***`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`_**_{Only in predicate}
Unsupported operators	`~ , !~ ,` `IS , IS NOT , IN , NOT IN`
Examples	Find issues that have been created during my last session: `created > lastLogin()`

Syntax	latestReleasedVersion(project)
Supported fields	AffectedVersion, FixVersion, custom fields of type Version
Supported operators	`= , !=`
Unsupported operators	`~ , !~ , > , >= , < , <=` `IS , IS NOT , IN , NOT IN ,` `WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues whose FixVersion is the latest released version of the ABC project: `fixVersion = latestReleasedVersion(ABC)` Find issues that relate to the latest released version of the ABC project: `affectedVersion = latestReleasedVersion(ABC) or fixVersion = latestReleasedVersion(ABC)`

Syntax	linkedIssues(issueKey) linkedIssues(issueKey,linkType)
Supported fields	Issue
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <=` `, IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
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")`

Page

Viewport

Confluence

Versions

Advanced searching - functions reference

Advanced searching

On this page

Related content

Still need help?

approved()

approver()

breached()

cascadeOption()

closedSprints()

completed()

componentsLeadByUser()

currentLogin()

currentUser()

earliestUnreleasedVersion()

elapsed()

endOfDay()

endOfMonth()

endOfWeek()

endOfYear()

everbreached()

futureSprints()

issueHistory()

issuesWithRemoteLinksByGlobalId()

lastLogin()

latestReleasedVersion()

linkedIssues()

membersOf()

myApproval()

myPending()

now()

openSprints()

outdated()

paused()

pending()

pendingBy()

projectsLeadByUser()

projectsWhereUserHasPermission()

projectsWhereUserHasRole()

releasedVersions()

remaining()

running()

standardIssueTypes()

startOfDay()

startOfMonth()

startOfWeek()

startOfYear()

subtaskIssueTypes()

unreleasedVersions()

updatedBy()

votedIssues()

watchedIssues()

withinCalendarHours()

Related content

Syntax	membersOf(Group)
Supported fields	Assignee, Reporter, Voter, Watcher, custom fields of type User
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <=` `, IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues where the Assignee is a member of the group "Jira-administrators": `assignee in membersOf("Jira-administrators")` Search through multiple groups and a specific user: `reporter in membersOf("Jira-administators") or reporter in membersOf("Jira-core-users") or reporter=jsmith` Search for a particular group, but exclude a particular member or members: `assignee in membersOf() and assignee not in ("John Smith","Jill Jones")` Exclude members of a particular group: `assignee not in membersOf()`

Syntax	pendingBy(user1,user2)
Supported fields	Custom fields of type Approval
Supported operators	=
Unsupported operators	`~ , != , !~ ,` > , >= , < , <= `IS , IS NOT , IN , NOT IN ,` `WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find issues that require approval by John Smith: `approval = pendingBy(jsmith)` Find issues that require by John Smith or Sarah Khan:`approval = pendingBy(jsmith,skhan)`

Syntax	projectsLeadByUser() projectsLeadByUser(username)
Supported fields	Project
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find open issues in projects that are led by you: `project in projectsLeadByUser() AND status = Open` Find open issues in projects that are led by Bill: `project in projectsLeadByUser(bill) AND status = Open`

Syntax	projectsWhereUserHasPermission(permission) For the `permission` parameter, you can specify any of the permissions described on .
Supported fields	Project
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find open issues in projects where you have the "Resolve Issues" permission: `project in projectsWhereUserHasPermission("Resolve Issues") AND status = Open`

Syntax	projectsWhereUserHasRole(rolename)
Supported fields	Project
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
Examples	Find open issues in projects where you have the "Developers" role: `project in projectsWhereUserHasRole("Developers") AND status = Open`

Syntax	releasedVersions() releasedVersions(project)
Supported fields	AffectedVersion, FixVersion, custom fields of type Version
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <= IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`
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))`

Syntax	startOfDay() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find new issues created since the start of today: `created > startOfDay()` Find new issues created since the start of yesterday: `created > startOfDay("-1")` Find new issues created in the last three days: `created > startOfDay("-3d")`

Syntax	startOfMonth() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find new issues created since the start of this month: `created > startOfMonth()` Find new issues created since the start of last month: `created > startOfMonth("-1")` Find new issues created since the 15th of this month: `created > startOfMonth("+14d")`

Syntax	startOfWeek() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find new issues since the start of this week: `created > startOfWeek()` Find new issues since the start of last week: `created > startOfWeek("-1")`

Syntax	startOfYear() 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	Created, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators	`= , != , > , >= , < , <=` *`WAS , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED`__{Only in predicate}
Unsupported operators	`~ , !~ , IS , IS NOT , IN , NOT IN`
Examples	Find new issues since the start of this year: `created > startOfYear()` Find new issues since the start of last year: `created > startOfYear("-1")`