Skip to end of banner
Go to start of banner

Issue Updates JQL Functions

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLES

Find issues which were moved between 2 or more projects. 

movedProjectsCount >= 2 

  • No labels