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 Aliases
UpdatedByUsersCount
Search for issues which 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 which 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 which 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 which 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 which 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 which were moved between projects.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues which 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")
Warning: Due to Jira plugin system limitation it is impossible to build a command which supports searching from/to. The query will find all issues which were in SEARCH or DATA at some point.
MovedProjectsCount
Search for issues which 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 which were moved between 2 or more projects.
movedProjectsCount >= 2