Try it free ☁Cloud 🖥Data Center
| Info |
|---|
The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
On this page:
|
|---|
Issue Updates JQL keywords
UpdatedByUsersCount
Search for issues that were updated by a particular number of users.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues updated by more than 5 users.
| Code Block |
|---|
updatedByUsersCount > 5 |
UpdatedBy
Search for issues that were updated by a particular user/users.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues that were updated by Helen or Daniel:
| Code Block |
|---|
updatedBy in ("helen", "daniel") |
TransitionedBy
Search for issues that were transitioned by a particular user/users.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues that were transitioned by Helen or Daniel:
| Code Block |
|---|
transitionedBy in ("daniel", "helen") |
LoggedTimeBy
Search for issues on which particular users reported time.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues on which Helen or Daniel reported time.
| Code Block |
|---|
loggedTimeBy in ("daniel", "helen") |
UpdatedOnDates
Search for issues that were updated on a particular date. This keyword works with date-related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
Also see:
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues that were updated between midnight 1 June and midnight 2 June.
| Code Block |
|---|
updatedOnDates>="2020/06/01" AND updatedOnDates<"2020/06/02" updatedOnDates < now() |
LastUpdatedBy
Search for issues that were last updated by a particular user.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues that were last updated by admin.
| Code Block |
|---|
lastUpdatedBy="admin" |
MovedProjects
Search for issues that were moved between projects.
From , movedProjects is not supported for new customers. The keyword will not be indexed and using it in a query will not return and issue. Customers who installed the app prior to this date are not affected by this change. See the deprecation notice to learn more.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
Find issues that belonged to a different project and were moved. For instance, the following query finds issues that were in projects SEARCH and DATA.
| Code Block |
|---|
movedProjects in ("SEARCH", "DATA") |
| Note |
|---|
Due to a Jira system limitation, it is impossible to build a command that supports searching from/to. The query will find all issues that were in SEARCH or DATA at some point. |
MovedProjectsCount
Search for issues that were moved between a number of projects.
From , movedProjectsCount is not available to new customers. The keyword will not be indexed and using it in a query will not return and issue. Customers who installed the app prior to this date are not affected by this change. See the deprecation notice to learn more.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues that were moved between 2 or more projects.
| Code Block |
|---|
movedProjectsCount >= 2 |