Try it free ☁Cloud 🖥Data Center
The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
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.
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:
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:
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.
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.
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.
lastUpdatedBy="admin"
MovedProjects
Search for issues that were moved between projects.
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 which were in projects SEARCH and DATA.
movedProjects in ("SEARCH", "DATA")
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.
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.
movedProjectsCount >= 2