Try it free: ☁Cloud 🖥Data Center
| Info |
|---|
The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
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.
| Code Block |
|---|
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:
| Code Block |
|---|
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:
| 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 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.
| 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 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.
| Code Block |
|---|
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.
| Code Block |
|---|
movedProjectsCount >= 2 |