Versions Compared

Old Version 5

changes.mady.by.user Jack Nolddor

Saved on

compared with

New Version Current

changes.mady.by.user Jack Nolddor

Saved on

Key

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

Description:

Excerpt

Perform searches based on the start of the current quarter of year.
See also: endOfQuarter()


Syntax

startOfQuarter()
startOfQuarter(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. startOfQuarter("+1") is the same as startOfQuarter("+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 new issues created since the start of this quarter of year:

Code Block
languagesql
themeConfluence
created >= startOfQuarter()

• Find new issues updated since the start of last quarter of year:

Code Block
languagesql
themeConfluence
updated >= startOfQuarter("-1")

• Find resolved issues since a month after the start of current quarter of year:

Code Block
languagesql
themeConfluence
resolved >= startOfQuarter("+1M")

Real World Use Cases:

· JRASERVER-69535 - Add a StartOfQuarter() function to JQL (by TomB).
· 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