Is there a "startOfQuarter" like there is a "startOfWeek" in JQL?

[Fahad Akhtar]

Hi,

My team and I want to generate quarterly reports. Can we use "startOfQuarter" instead of using 2019/01/01 - 2019/03/31?

Thanks

[Jack Nolddor [Sweet Bananas] · Accepted solution]

Hi Fahad Akhtar,

Sadly, there is not a native function like startOfQuarter(), but you can have a similar approach using, for example:

created >= startOfYear() and created <= startOfYear("+90d")

OR

created => startOfMonth() and created <= startOfYear("+3")

Additionally, you can also use JQL Booster Pack third-party app which truly allows you to use the startOfQuarter() function. Here is the documentation page for this function.

However, this complement is only available on Server / DataCenter and not on Cloud,
Regards

[Jack Brickey · Accepted solution]

another option... You could create 4 filters, one for each quarter

• Q1 - project = myproject and created >= startOfYear() and created <= startOfYear("+90d")
• Q2 - project = myproject and and created >= startOfYear("+91d") and created <= startOfYear("+181d")
• etc...

[Avinash Bhagawati {Appfire} · Accepted solution]

Hi @Fahad Akhtar ,

Alternatively you can use startOfMonth. For example,

created > startOfMonth("-3")

Thanks,

Avinash

[Ismael Jimoh]

@Avinash Bhagawati {Appfire}  @Fahad Akhtar 

StartOfMonth(-3) does not equate to last quarter but rather the issues created from this month for the past 3 months.

@Jack Brickey  suggestion of using year is the ideal solution here.

[Ismael Jimoh · Accepted solution]

No there’s not out of the box.

Not sure if this can be achieved with an add-on like scriptrunner though, since it allows you build custom jql functions(on the server version)

You may also want to look at one of the repoerting addons that extend the default JQL provided by Jira.

Cheers

[Ismael Jimoh]

There’s an existing feature request for it here: https://jira.atlassian.com/plugins/servlet/mobile#issue/JRASERVER-69535

[Karen Aiken]

Feature request link - non-mobile view -
https://jira.atlassian.com/browse/JRASERVER-69535

Cloud feature request -
https://jira.atlassian.com/browse/JRACLOUD-20359