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 which 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 which 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 that were in projects SEARCH and DATA.
movedProjects in ("SEARCH", "DATA")
Due to Jira plugin system limitation, it is impossible to build a command that supports searching from/to. The query will find all issues which 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