Versions Compared

Old Version 7

changes.mady.by.user Deborah Scott

Saved on

compared with

New Version 12

changes.mady.by.user Deborah Scott

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Image RemovedImage Added

Try it free

:

☁Cloud 🖥Data Center

Info

The instructions on this page describe how to execute a JQL search using JQL Search Extensions.

On this page:

Table of Contents
minLevel
1
2
maxLevel
7
2
outlinefalse
styledefault
excludeTry it free
typelist
printabletrue

Issue Updates JQL

Keywords

keywords

UpdatedByUsersCount

Search for issues that were updated by a particular number of users. SUPPORTED OPERATORS 

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

Examples

Find issues updated by more than 5 users. 

Code Block
updatedByUsersCount > 5

 

UpdatedBy

Search for issues that were updated by a particular user/users. SUPPORTED OPERATORS 

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

Examples

Find issues which that were updated by Helen or Daniel:

Code Block
updatedBy in ("helen", "daniel")

 

TransitionedBy

Search for issues that were transitioned by a particular user/users. SUPPORTED OPERATORS 

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

Examples

Find issues which that were transitioned by Helen or Daniel:

Code Block
transitionedBy in ("daniel", "helen")

 

LoggedTimeBy

Search for issues on which particular users reported time. SUPPORTED OPERATORS 

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

Examples

Find issues on which Helen or Daniel reported time. 

Code Block
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 

 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

Examples

Find issues that 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 

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

Examples

Find issues that were last updated by admin. 

Code Block
lastUpdatedBy="admin"

MovedProjects

Search for issues that were moved between projects. SUPPORTED OPERATORS 

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

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. 

Code Block
movedProjects in ("SEARCH", "DATA")
Infonote

Due to Jira plugin to a Jira system limitation, it is impossible to build a command that supports searching from/to. The query will find all issues which that were in SEARCH or DATA at some point. 

 

MovedProjectsCount

Search for issues that were moved between a number of projects. SUPPORTED OPERATORS 

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 that were moved between 2 or more projects. 

Code Block
movedProjectsCount >= 2