This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.

Take a look here! If you have any questions please email support@appfire.com

Issue Updates JQL Functions

 

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

=

!=

~

!~

>

>=

<

<=

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

=

!=

~

!~

>

>=

<

<=

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

=

!=

~

!~

>

>=

<

<=

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

=

!=

~

!~

>

>=

<

<=

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. 

 

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

=

!=

~

!~

>

>=

<

<=

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.

 

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

EXAMPLES

Find issues that were last updated by 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

=

!=

~

!~

>

>=

<

<=

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. 

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

=

!=

~

!~

>

>=

<

<=

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.