Issue updates

The examples on this page describe how to build 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

 

Example:

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

Find issues on which Helen or Daniel reported time. 

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

 

Example

Find issues that were updated between midnight 1 June and midnight 2 June.

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

Find issues that were last updated by admin. 

MovedProjects

Search for issues that were moved between projects. 

From Sep 30, 2024 , 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

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. 

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

 

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

Find issues that were moved between 2 or more projects.