Versions Compared

Version Old Version 3 New Version Current
Changes made by

Jack Nolddor

Jack Nolddor

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

Excerpt

Perform searches based on the end of the current quarter of year.
See also: startOfQuarter()


Syntax

endOfQuarter()
endOfQuarter(duration)

Where 'duration' is an optional increment of (+/-)nn(y|q|M|w|d|h|m).
If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfQuarter("+1") is the same as endOfQuarter("+1q").
If the plus/minus (+/-) sign is omitted, plus is assumed.

Available sincev1.8.0-RELEASE
Supported fieldsCreated, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators

= , != , > , >= , < , <=
WAS* , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED*


* Only in predicate 

Unsupported operators~ , !~ IS , IS NOT , IN , NOT IN


Examples:

• Find issues due by the end of this quarter of year:

Code Block
languagesql
themeConfluence
due <= endOfQuarter()

• Find issues due by the end of next quarter of year:

Code Block
languagesql
themeConfluence
due <= endOfQuarter("+1")

• Find issues due a month after the end of current quarter of year:

Code Block
languagesql
themeConfluence
due <= endOfQuarter("+1M")

Real World Use Cases:

· JRASERVER-20359 - Expand JQL to support date-oriented functions (Month, Day, Year) so there is more precision (by Betsy Walker)
· fixversion = all releases within a date range or quarter (by Luke Hale at ATLASSIAN Community)






JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2